How To Import Opening Bank Balances
- Michelle Russell
This is done by either importing a Journal or manually entering the Journal in Moveware. To import:
The Journal is required to be in Status U (fully posted):
The format of the Journal is:
The last reconciled amount as a debit
All outstanding cheques – written but not cleared, are to be credits
A Suspense Account is the balancing Account which will hold the book value until the Balance Sheet is brought into Moveware.
This process allows outstanding cheques to be cleared individually.
If there are outstanding deposits, if the branch/company accounts for them prior to deposit, this would be done in the same manner as the outstanding cheques but as debits for the pending balance increase.
The format of the Journal will follow the same as the excel:
The portions highlighted in yellow are not to be included in the import and are for reference only. The file type is csv and should contain no commas, commas indicate a new field.
Once the Journal is complete, when the next month’s reconciliation is done, the ending balance will be included in the reconciliation to bring the account to the last ending amount, then the rest of the reconciliation is done as normal. In this example, we would include the outlined amount as it was the ending balance for 03/31/25 when completing the April reconciliation.
