Windward Software Wiki

Hello,

There are a few things that we need for the Bank rec. Essentially we need the bank reconciliation that brings us to the go live date. The main things we need off of this bank reconciliation are:

1. The bank account balance at the go live date.
2. The listing of the uncleared transactions as of that date (Or the total at the very least)
3. The GL account balance of the bank account on that date. This leads us to the related starting entries because this figure comes from your starting trial balance.

Additionally:

1. I would like to see a trial balance for your go live date
2. I would like to see an Aged AR for your go live date
3. I would like to see an aged AP for your go live date

The trial balance is important because it is possible that the GL balance of the bank account on that day is not correct. The Actual account balance off of the previous Bank Rec plus the total of the uncleared transactions must equal the GL balance of the bank account from the trial balance.

The next thing to check quickly is that the Aged AR, and Aged AP match up from your previous reports to system five. There are a couple checks I would like to make to make sure the Aged AR and AP were set up correctly (this relates to the starting journal entry, which mirrors your trial balance for your go live date). The above information will give us enough information to make sure the books are started correctly and get that first bank rec going. As the accountants keep telling me, if you get the bank reconciliation correct, everthing else should follow along nicely. After this we will need all of the daily depisit information:

1. System Five contains all of the POS transaction reports, which if ran correctly should mirror your daily total slips on your visa and debit transactions etc.
2. We need your daily deposit slips for visa, and debit, etc. transaction.
3. If you keep your cash on hand and don't deposit these daily slips we will also need your deposit book so we can enter the deposits for cheques and cash.

With all of this information and some instruction you should be able to fix things up right back to your go live date. Any outages should become easy to identify at this point, but from there it may take further investigation to find the outage. This further examination can be done after the fact using the techniques I will show you. Talk to you soon.

:!:Do not use G/L accounts such as the cash clearing, A/R, A/P etc. on a bank reconciliation. In general bills and invoices have no regard for the bank reconciliation and may delete or change entries normally protected by the bank reconciliation.