Import cleared checks
Sparkrock 365 provides the capability for you to import a .csv file to update the Date Cleared field on check ledger entries.
Import cleared checks setup
Before you can perform an import, you must perform the following setup:
Verify the import data exchange definition field mapping.
Import the data exchange definition template.
Add the import template to the Bank Export/Import Setup page.
Link the bank account to the import template.
The following sections include detailed information about this setup.
Verify import data exchange definition field mapping
The data exchange definition template specifies the fields that are to be imported and how the fields in the file map to the fields in Sparkrock 365.
Import the data exchange definition template
After you have verified the import data exchange definition field mapping, you can import the data exchange definition template.
To import the data exchange definition template
To download the default template, select the following link:
Choose
, enter data exchange definitions, and then choose the related link.The Data Exchange Definitions page opens.
On the action bar, choose Import/Export > Import Data Exchange Definition.
The Import dialog box appears.
Choose Choose, select the file that you want to import, and then open the file.
Add the import template to the Bank Export/Import Setup
After you import the data exchange definition template, add the template to the Bank Export/Import Setup page.
To add the import template to the Bank Export/Import Setup
Choose
, enter bank export/import setup, and then choose the related link.The Bank Export/Import Setup page opens.
On the action bar, choose New.
A new row appears.
In Code, specify a code to represent your bank statement import.
In Name, enter a name for this import.
In Direction, specify Import.
In Processing Codeunit ID, specify 1270.
In Data Exch. Def. Code, specify your data exchange definition.
Select the Prevent Non-Latin Characters checkbox.
If required, specify values in other fields.
Link the bank account to the import template
You must link the import template that you are going to use to your bank account.
To link the bank account to the import template
Choose
, enter bank accounts, and then choose the related link.The Bank Accounts page opens.
Select the bank account for which you want to link the bank statement import template, and then on the action bar, choose Manage > Edit.
The Bank Account Card page opens.
On the Transfer FastTab, in Bank Statement Import Format, add the import template that you want to use.
To import cleared checks
Choose
, enter bank accounts, and then choose the related link.The Bank Accounts page opens.
Select the bank account for which you want to import cleared checks, and then on the action bar, choose Manage > Edit.
The Bank Account Card page opens.
On the action bar, choose Home > Import Cleared Cheques.
The Import Cleared Cheques page opens.
On the Options FastTab, specify values as required, and then to proceed, choose OK.
The Select a file to import dialog box appears.
Drag a file into the dialog box or browse to the .csv file that you want to import.
Sparkrock 365 imports the data from the file, and then displays a dialog box that indicates the number of transactions that were cleared or exceptions that were found.
If one or more exceptions were found, Sparkrock 365 creates an exception file, and then places the file in your browser downloads folder.
Sparkrock 365 considers a transaction an exception in the following cases:
The Transaction Date in the import file is earlier than the Posting Date in the check ledger entry.
The amount in the import file does not match the amount in the check ledger entry.
Related information
Manage and reconcile your bank accounts
Bank account reconciliation date cleared
Feedback
To send feedback about this page, select the following link: