1 / 4

Balance Spreadsheet

Centre Club d’Âge d’Or de la Vallée Inc. Le trésorier / trésorière. The balance spreadsheet is easy to use and will tell you if you have made any mistake. The amount in this line is generated from the previous month. Automatically generated. Balance Spreadsheet.

lcecil
Download Presentation

Balance Spreadsheet

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Centre Club d’Âge d’Or de la Vallée Inc. Le trésorier / trésorière The balance spreadsheet is easy to use and will tell you if you have made any mistake. The amount in this line is generated from the previous month. Automatically generated. Balance Spreadsheet Amount from your receivables Petty Cash amount Amount from your Expenses Amount less petty cash (calculated automatically) Amount you have in the bank per your records amount shown on the bank statement Checks not cashed Total Amount you have in the bank per the bank statement This sheet shows the month of Oct is balanced

  2. Centre Club d’Âge d’Or de la Vallée Inc. Le trésorier / trésorière If the month is not balanced, there is a mistake in one of the following areas. You have an expense or receipt not entered You may have made a check for a different amount shown on your expense sheet. A check may not have been cashed and has expired A check may still be outstanding and not recorded incorrect entry of the bank statement entered May be others Balance Spreadsheet Checks not cashed prior to the statement should be entered here Cancelled checks should be entered here

  3. Centre Club d’Âge d’Or de la Vallée Inc. Le trésorier / trésorière I found this spreadsheets to be very helpful. this verifies all your entries, because you are comparing your entries to the banks entries. In one case I hade made a check for $60.10 and I had entered the amount in my expense sheet as $60.00 All my reports sheet showed a balance month. When I applied the information to the balanced sheet I was 10¢ out. This mistake took me 2 hours to find. At first I suspected my spreadsheet, then I suspected a bank error (ha ha banks don’t make mistakes)at this point I started to verify my amounts against the bank amount and found my mistake. Because the check was three monts late in being cashed I had to go back three months and make the corrections. (that took another 2 hours) Balance Spreadsheet Make sure you check all your amounts against the bank statement , check to make sure all checks are accounted for, check for the proper amount on the bank statement. After all your entries if you get Mois balancé you can be confident that all your entries are correct.

  4. Centre Club d’Âge d’Or de la Vallée Inc. Le trésorier / trésorière Balance Spreadsheet Now you have all the tools need to keep track of the receipts and expenses end of this presentation

More Related