Get Proof Of Cash Template Excel

This guide provides a step-by-step approach for completing the Proof Of Cash Template Excel. Users at any level of experience will find clear instructions to help navigate the form's various sections.

Follow the steps to complete the Proof Of Cash Template Excel effectively.

1. Press the ‘Get Form’ button to obtain the Proof Of Cash Template Excel and open it in your preferred editor.
2. Begin by entering the company name in the designated field labeled 'Company:'.
3. Fill in the 'Control No.' and 'Account:' fields to identify the specific account details.
4. Indicate the month ended by writing the relevant date in the 'Month ended:' field.
5. Enter the beginning period bank reconciliation details by providing data in their respective sections, like 'Balance per Bank:' and 'Deposits in transit:'.
6. Complete the outstanding checks section for both the prior and current months.
7. Proceed to fill in the 'Monthly Receipts' section, starting with the amounts under the appropriate categories.
8. Continue through the form by detailing the 'Monthly Disbursements', ensuring accuracy in the recorded figures.
9. Calculate the 'Adjusted Balance' and ensure it matches the necessary sections as indicated.
10. Update the sections for 'Balance per Books:', 'Monthly Service Charge:', 'NSF Checks Returned:', and any bank transfers or errors.
11. Complete the final adjustments, ensuring that the adjusted balances align as required.
12. Save your changes, then download, print, or share the completed form as needed.

Complete your documents online today for efficient financial management.