Bank beginning balances upload

Question

We need to load uncashed checks to a new bank. Other than manually entering one batch per check, is there any way to import this information? Ty.

WWOOLMER · Answer

Yes, can be done, for example, as direct bank entries. 
 Bank entries screen : 
 Create a single bank entry of the type you want. Add the entry, don't post it. 
 File / Export - select Excel format. This will create an example Excel template. 
 Test changing the example file - including new reference numbers. Close Excel. Then file / import to the bank entries screen. (Delete the test entry, don't post it) 
 Once you have it working , create your bulk entries in the template and import it.

Sage 300

Bank beginning balances upload

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING