Load Open Items

This feature allows you to import bank data into Compeat from a spreadsheet. This is useful when converting from another system. If there are uncleared checks, deposits, adjustments, etc., from the previous system, you can load them into Compeat using this utility. This will not affect the general ledger; it only adds outstanding transactions that should clear through your bank into the Bank Reconciliation data in Compeat.

The following are the transaction type choices listed in the Load Bank Reconciliation Items sample spreadsheet:

If you use type 1, 2, 6 or 7 you must define if this should be a positive or negative adjustment to the bank account. If you do not use a negative sign, the amount will show as a debit to the bank account. Type 3 and 4 for checks and electronic fund transfers show as credits by default no matter if you have a negative or positive number on the spreadsheet.

This feature is similar to several other import features in Compeat and is described in the Load Open Items Procedure topic.

Visit the Compeat Support Website for additional information on this topic and more.