Once history is imported, the bank account balances may be affected as your General Ledger bank balances will be imported.
To finalize the Bank Reconciliation, follow the below steps:
In the first article, Onboarding: How to reconcile the first month's bank account?, you would have entered the Opening Bank Balances. These now need to be removed since the bank G/L balance has now been imported.
To remove the bank account opening balances, in Accounting / Chart of Accounts / Opening Balances:
Select the Hotel ID on the top left then remove the Bank Actual Balances as of the hotel's start date.
This was a journal entry, ensure all data is removed, including bank balances and any offsets that may have been entered into Owners Equity or another offset COA and Save the entry.
If the bank accounts were reconciled to the actual bank balance, the first month will now be out of balance by the difference between the Bank Actual Balance vs the G/L Bank Balance.
To correct, navigate to the Register tab, select Reconcile on the top right of the page. Open the first month that you were with Inn-Flow, in this example, 01/24.
You can see the Variance now appears.
To correct, first select Reopen Reconciliation on the bottom right of the page.
If the Variance is a positive number, like above, this can be entered as a deposit by drilling into the Other Deposits section as shown below.
Click the Add Transaction on the top right of the page and enter all details.
Vendor name would be PRIOR DATA MANUAL, Date would be the first of that month, and the COA would be 12999 PRIOR BANK BALANCES (Bank Reconciling Entries)
If the variance is a negative number, this can be entered as a withdrawal by drilling into the Other Withdrawals section as shown below.
Click the Add Transaction on the top right of the page and enter all details.
Vendor name would be PRIOR DATA MANUAL, Date would be the first of that month, and the COA would be 12999 PRIOR BANK BALANCES (Bank Reconciling Entries).
Making this update should bring the variance to zero. You can mark this as Reconciled at the bottom right of the page.
Making these updates should clear out the remaining balance in 12999 PRIOR BANK BALANCES (Bank Reconciling Entries), and in COA 21010 Accounts Payable for Implementation.