Page Comparison

...

Procedure

...

1. Ensure that on the last day of trade, for each bank account that is reconciled, that a statement is printed and all transactions are accounted for in the old system (including credit cards and petty cash)
2. Ensure that the last bankrec has been completed on the old system for each Bank Account that you reconcile.
3. Ensure that the closing bank balance plus/minus any unpresenteds lines up to the General ledger Bank Account on the old system for each bank account
4. Identify the cut over date for the last Bank Reconciliation on the old system .
5. In Readysell, on the bankings list view, select the "all bankings" view and check there are no bankings prior to the date you are going to use for the first bank reconciliation. If there are any, contact Readysell for assistance.. 
6. Create your openning opening banking and any unpresented items and reverse the general ledger effect of those openning items.
   1. Enter a bank payment or bank deposit dated the same date as your last bank reconciliation in your old system or the last trading day of your old system. (you need to work out first of all if there have been any transactions accidently back dated to go live date, if so they need to be reversed and re entered as of go live date)>
      The value of the transaction stands for the amount that has been fully presented (brought forward = the sum of the opening less/plus the unpresented) with the correct date.
      That is either a payment if you are in overdraft or a deposit if you have money in the bank as a brought forward.
      The general ledger account selected should and dissected against can be the suspense or conversion data gl account.
   2. Create a banking for each amount that is unpresented on the bank statement.
      That is either being a payment and/or deposit with the correct date for each unpresented transaction .
      The general ledger account selected should be suspense.Create a general journal posting between bank and the suspense account to clear the suspense account and bank account effects of the transactions in step a and b above. Add up all your unpresented items and your opening balance. Then post this general journal
   3. Uncheck the 'Is Bank' checkbox off the general ledger bank account before the brought forward journal is entered. Then click the save button.
   4. dating it correctly, before you commence any bank reconcilation to stand for the Closing Position from your old system. That is bank statement plus and/or minus (+/-) all unpresented.
   5. This journal can be dissected against suspense just for now, however the value in the suspense gl account will need to be taken into account with the brought forward journal.
   Check the 'Is Bank' checkbox off the general ledger bank account before the brought forward journal is entered. Then click the save buttoncan be either the suspense or conversion data account.
   6. The reversal of the dissection against the suspense or conversion data general ledger account, can be handled when you insert the starting General Ledger Brought forward Journal.
7. Make sure the GL Bank = Bankings for that period or date range.
   Either browse the account or run a gl report and bankings report
8. Check that no general ledger journals have been posted to bank on or before the date of the first bank reconciliation.
9. Create an Opening Bankrec as starting bankrec with opening balance of zero and closing balance to be bankstatement bank statement close and correct date. (the date here is very important)
10. Present the brought forward banking only and finalise the first starting bank reconcilation reconciliation to stand for the closing bank reconcilation reconciliation from your old database.
11. Post the first bank reconciliation.
12. Run the bank reconciliation report and make sure that the first bankrec closing = the general ledger figure for that date/period.
13. At this point now the site can commence with the next Bank Reconciliation.

...

1. .

...

• DELETE FROM dissection WHERE (BankDepositLine IS NOT NULL OR BankPaymentLine IS NOT NULL) AND TransactionNumber IN (X, Y, Z);

...