IS there an update template to use for importing cleared checks? Help menu not too helpful on this one
IS there an update template to use for importing cleared checks? Help menu not too helpful on this one
Thank you for your post John M Jankowski!
What version and update of Sage 300 CRE are you currently using? The version will reference 9.8 or 13.1 in your Help, About in the software. (example 13.1 Rev 7 Acc Update 6)
Are you working Cash Management?
Currently using 9.8 and utilize CM. We will be upgrading to 13.1 in the Fall
Thanks for that info John!
The CM>Help Topics>Index>Import Cleared Checks topics covers all the information you would need to import cleared checks into CM. Everything from comma-delimited templates to troubleshooting rejected entries.
You can also get a Cleared Checks template handout directly from the Tools>Import Cleared Checks feature under "Print Template".
The file essentially has four required fields: Bank ID, Check number, Amount and Date.
Example: TERPBK,1550,79.00,06262003
TERPBK is the bank ID from the software, 1550 is the check number, 79.00 is the amount, and 06262003 is the date.
NOTE: The Date format selected on the General tab (Tools > Options) determines the date format for the import text file. You can use U.S. (mmddyyyy), international (ddmmyyyy), or military (yyyymmdd). Separators (hyphens or slashes) are optional, but Import Cleared Checks recognizes them as separators within the date. (For example, you can use 06262003, 06-26-2003, or 06/26/2003).
Hope that helps!
Hi John,
Many people prefer to import based on bank account number instead of Bank ID. Here is the information from article 30207 in the Sage Knowledgebase:
You will need to open the fixed format template cm_fixed.tpl in the xx:\\Timberline Office\9.5\Accounting\Template folder and copy this line :
AFSL BACCT Account Number 0 15 0 0 0 15 1
You will then need to paste that line over this line in your comma separated value template:
AF TBNKACC
This will allow the use of the bank account number in you import file rather than the bank ID.
Let us know how it goes!
*Community Hub is the new name for Sage City