1 / 6

Receivable Spreadsheet

Centre Club d’Âge d’Or de la Vallée Inc. Le trésorier / trésorière. Using the information on the deposit spreadsheet (shown on the left) enter all the amounts shown on the deposit sheet in the proper account of the receivable spreadsheet.

tvega
Download Presentation

Receivable 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 Using the information on the deposit spreadsheet (shown on the left) enter all the amounts shown on the deposit sheet in the proper account of the receivable spreadsheet . This column is the tax total amount entered as shown on the deposit slip This column is the total amount deposited as shown on the deposit slip Receivable Spreadsheet The petty cash entry is shown in the first column

  2. Centre Club d’Âge d’Or de la Vallée Inc. Le trésorier / trésorière Using the information on the deposit spreadsheet (shown on the left) enter all the amounts shown on the deposit sheet in the proper account of the receivable spreadsheet . All of the entries in the deposit slip are entered in the proper column category. Receivable Spreadsheet Example : All games (Poche, flechette, pool etc.. are totals in the Jeux Column Rentals (Locations) also are totaled and entered in the Location Column the location déplacement is entered using the information on the deposit sheet

  3. Centre Club d’Âge d’Or de la Vallée Inc. Le trésorier / trésorière Using the information on the deposit spreadsheet (shown on the left) enter all the amounts shown on the deposit sheet in the proper account of the receivable spreadsheet . All of the entries in the deposit slip are entered in the proper column category. This column verifies that the total column amount is equal to all column entries. Receivable Spreadsheet If the difference is not equal to 0 you have made a mistake in one of the column

  4. Centre Club d’Âge d’Or de la Vallée Inc. Le trésorier / trésorière This spreadsheet has the formulas to make all the calculations. Once you are familiar with the column account, entering the information is simple. Receivable Spreadsheet One entry that requires special attention is the Bar entry. From the Bar report submitted by the Bar manager you enter the deposit using the Bar report. The next slide shows the details

  5. Centre Club d’Âge d’Or de la Vallée Inc. Le trésorier / trésorière Receivable Spreadsheet if a minus sign is in front of the letter the entry is negative To enter a Bar entry notice the letters in brackets in the receivable spreadsheet below .These letters indicate the column shown in the Bar report The entries in this column are the ones deposited in this line This photo shows the first and last part of the spreadsheet

  6. Centre Club d’Âge d’Or de la Vallée Inc. Le trésorier / trésorière This receivable spreadsheet is simple to use. Make sure you do not overwrite a cell with a formula. If you overwrite a cell that contains a formula your entries will not total properly. Receivable Spreadsheet End of this presentation

More Related