Bank reconciliation problem!

Posted by mep_socom PM | on Sat, 25/02/2012 - 18:29 3170 12 comments | report

I am trying to do a bank reconciliation from aug 10 - aug 11, all invoices have a cc receipt attached and I have entered into a spreadsheet then totalled for each month. I have then gone through the bank statements and identified which card machine day totals relate to which days and which have gone in after the en of one month and into the next etc. However for the whole year the total amount showing up on bank statements is considerably less than what I have totalled of our invoices! I am unsure why this is and what to do next, any help please?

Comments

There are 12 comments. Login or register to view them.

September Perhaps?

MrDSGrace | Sat, 25/02/2012 - 22:00

Card fees

tom123 | Sun, 26/02/2012 - 08:01

use this for fast check

gp | Sun, 26/02/2012 - 11:49

What percentage is the difference?

young ronaldo | Mon, 27/02/2012 - 10:22

Have you checked the formulae

Turbo | Wed, 29/02/2012 - 11:26

transposition error?

goblinf | Wed, 29/02/2012 - 11:47

Is there a savings account,

JWB | Wed, 29/02/2012 - 11:52

Do you have a full house?

vstrad | Wed, 29/02/2012 - 18:24

chargebacks

Andrewr | Thu, 01/03/2012 - 11:25

Put the statement numbers on the spreadsheet

Chris Smail | Thu, 01/03/2012 - 11:50

American Express (Amex) problems

DMGbus | Thu, 01/03/2012 - 13:37

Check the merchant services statements

VLH | Thu, 01/03/2012 - 16:51