Weekly Cash Balance Report

Our boss requires us to prepare this report every Saturday but the cut-off of the data is Friday.  This is very useful especially if you have a lot of bank accounts that needs to be monitored.

 Here are the explanation on how we fill up this report:


COMPANY : represents the company name of the particular account
BANK:  the bank where the account of the company is deposited
ACCT. NO. : the account number of the company
BALANCE PER BANK:  this is the actual cash in bank on that particular Friday
PREVIOUS BALANCE PER BOOK:  this is the book balance of your account of last week's Friday
DEPOSIT/COLLECTION:  reflects all the deposits made to the account this week
CURRENT CHECK ISSUED:  reflects the check issuance from last Saturday up to this Friday
CURRENT BALANCE PER BOOK:  previous balance per book plus deposit/collection less current check issued
POST DATED CHECK:  as you can see, we have 7, 14, 21 and 30 days on this section.  To determine what section your check issuance falls under, you need to prepare a legend first. (see the legend on the bottom part of the report.)
BALANCE PER BOOK:  current balance per book less the PDC issued
GOOD UNTIL:  If your account is still positive on the BALANCE PER BOOK portion, you will put the last day on your legend here.  But if the account goes overdraft, check with your book on when that particular account will be overdraft then put the date before that day on the GOOD UNTIL portion.

Passbook should be updated every Friday.  For checking accounts, you can ask your bank to print out an interim bank statement.

For excel file of this report, please leave your email on the comment portion.