Account Reconciliation>double-click on account to reconcile.

Enter the Ending Balance off of the statement.  Make sure ‘Show All Transactions’ is checked.

Sort by Description, and check all the voided payments that cancel each other out (‘Difference’ # should stay the same.)

On deposits side, sort by date and check all the deposits shown on the statement, writing on the statement which ones you mark.

Switch to payment side, sort by Control Number, and check off all the check numbers that cleared, writing on the statement which ones you mark.

Sort by amount and then status, and check off all the withdrawals shown on the statement, writing on the statement which ones you mark.  You will be missing the entry for the service charge.  Pull up the bank vendor (CITBAN), open and duplicate last month’s, changing the date and amount.  Process.

 

If a payment seems missing, highlight the amount, and check the following:

• Look up the vendor, was it paid with the wrong account?
  • Search for it under the credit card account.  If it was recorded as ‘manual’, void the payment and choose bank, and reprocess.
• Sort by status: is it one of those not checked off, but entered incorrectly?

If payment was recorded, but amount was simply wrong:

• Find the original PO (verify that their amount is actually correct), unprocess, void payment, adjust PO, make sure method of payment is correct (it goes back to charge), and reprocess.  Back on your reconciliation screen (close and reopen), select both the positive and negative payment you just voided.

If it is still simply missing, highlight and take to Tim.

Sort by date, then status.  Is everything not checked off valid payments? Possible reasons:

• Will it come through on next month’s statement?  If so, it can be left alone.
• If we truly didn’t pay it (they didn’t receive check) and we don’t owe it, unprocess, void, and delete it.

 

After everything is selected on the statement, and no old/invalid records are sitting there (your Difference should be $0/blank), export the reconciliation. Click Print>1 Account Reconciliation>Yes (to save changes)>Export>OK>OK.  Save it in the Bank Statements folder (under Dropbox>Accounting Files on Drop Box>Accounting>Bank Statements), and title it CC account reconciliation, dd-mm-yy.  Next click ‘Reconcile’, and say Yes.  Close out and save.

Scan statement from the bank and save under Dropbox…Bank Statements.  Shred statement.