Hello,
For the first Bank Reconciliation Statement in Acumatica, after all historical records are imported and tied to prior system, instructions below. For example, say you are “Going Live” Feb 1, first bank rec in Acumatica 2/28, last bank rec in Excel 1/31.
- Gather list of Open/outstanding items as of prior Bank Statement dated 1/31.
- In Acumatica, enter Open Items from step 1 in GL with a Debit and Credit to Cash with Check Number or Deposit numbers listed separately on each line. Use Date 1/31.
- Begin Bank Reconciliation statement in Acumatica with Date 1/31.
- Use “Reconcile All” to mark 100% of historical transactions through 1/31 Cleared & Reconciled at the same time.
- Un-check Reconciled and Cleared boxes for the outstanding historical items listed in step 1. Uncheck CREDITS for checks/disbursements and un-check DEBITS for deposits.
At this point the 1/31 Bank rec will be completed with $0 difference at the top. Release 1/31 Reconciliation Statement.
The 2/28 Acumatica bank rec will be “normal” -- follow Acumatica instructions to complete a normal bank rec.
Hi Laura,
This totally answers a lot of other questions that I did have on how to clear those items, but all of our A/P checks paid out were not ported over individually. So that is my dilemma.
How do I clear them individually if they aren’t there as individual transactions?
Thank you for your fast response!
Hello,
You are going to create the individual checks with the debit and credit to cash via GL entry in step 2 posted by me above. In the 1/31 bank reconciliation statement you then clear one side of the debit/credit to cash and leave the other side of the step 2 entry as an open/outstanding check in the bank rec of 1/31.
The GL entry created in step 2 has no effect in GL - is a wash, debit/credit to cash account.
However, this entry creates debits and credits that are now seen in Bank Reconciliation screen. You can clear one side of 1/31 entry (step 5), leaving open/uncleared the credit side of the GL transactions representing checks and leave open the debit side of the GL entries representing outstanding deposits.