Eunhee's Accounting World

  Template #7 Cheque Tracking Sheet If your company issues many cheques, this tracking sheet can enhance your cash flow analysis and bank reconciliation process. By maintaining this form on a daily or weekly basis, you can monitor the outstanding cheque balances and better manage your bank balance. Additionally, during bank reconciliation or review, you can use this sheet to double-check outstanding transactions and verify balances. Finally, it allows you to view the complete cheque history in one place.  You can refer to the cash flow template I shared to see how this form can be applied to your cash flow analysis. 

Template #5 PPE Amortization Schedule This is a note for the PPE amortization schedules. You can include it to reconcile and compare the PPE balance with the Balance Sheet in the financial report. You may include any additional PPE assets held by your company as needed.  Regarding land, no additional recording is required; however, you may compare the carrying amount with your corporation's property assessment value. Vehicles – Refer to the amortization method, calculation approach, and corresponding journal entries. Also, review the CRA guidelines This form is set up to apply the half-year rule. Computer Equipment – Refer to the amortization method, calculation approach, and corresponding journal entries. Also, review the CRA guidelines This form is set up to apply the half-year rule. Equipment – Refer to the amortization method, calculation approach, and corresponding journal entries. Also, review the CRA guidelines This form is set up to apply the half-year rule. Furniture and F...

  Template #6 Daily, Weekly and Monthly CF By using this cash flow form, you can develop a comprehensive understanding of your company's cash flow on a monthly, weekly, and daily basis. It will assist you in forecasting cash flow for several months or even years, helping you prevent potential cash shortfalls or defaults. Review your primary sources of cash inflows—such as key customers—and cash outflows, including major vendors and expense categories. Cash flow drivers can vary significantly depending on the nature of your business and industry. Please refer to the formulas provided to better understand the underlying cash flow concepts. If there is sufficient interest, I will provide a more detailed explanation of this cash flow framework 1. Monthly CF Report 2. Weekly CF Report

Template # 0 Monthly Reporting Package   This monthly reporting package was prepared by me, but I still need to input my own figures. Please refer to the template without the numbers for now. It will be updated once the figures are finalized

  Template #4 The Monthly Vendor Statement List This form is designed to enhance recordkeeping and payment tracking. While you may receive statements periodically from your customers, not all AR clerks send them consistently. If you are an AP clerk, you can use this form to compile a monthly statement list, allowing you to actively track and follow up on missing statements. If you are a supervisor, you can review this list prepared by your AP clerk and encourage them to send reminder emails to customers for outstanding statements. Missing statements—especially from high-volume customers—can result in delayed or inaccurate entries in your P&L report and may cause account holds, potentially disrupting your ability to receive products on time.

  Template #3 Loan Schedules If your company decides to borrow funds from a financial institution , it's important to analyze the cash flow impact and the total interest expense . Once the loan terms —such as monthly payments, interest rate, and other conditions—are finalized, you should create an amortization schedule internally. This schedule can then be compared with the lender's figures to ensure accuracy and consistency. This is the journal entry for the financing arrangement and the corresponding monthly payment schedule .  If you have multiple loans, you can create a summary to consolidate the loan information and reconcile it with your trial balance or balance sheet.