![]() What amount can be obtained in the next 10 days, 15 days, 20 days, 30 days? and so on? Remember, we must create an aging schedule to break the total receivable amount into different time slabs.įor example, if the total receivable amount is ₹5 lakhs, then as an accountant, ensure how much one can receive in the next five days. One of the thumb rules in accounts is, “The longer the accounts balance outstanding is pending, the chance of collecting them is less likely.” ![]() #5 – Aging Schedule of Accounts Receivable Let us see the aging schedule in the below section. First, they must create an aging schedule for their payments. The accounts receivable job does not stop there. If there is no money, how to pay even if the due date is tomorrow? In such cases, the accounts receivable team significantly pushes the clients to make the payment on time. Based on the funds available, the proprietor decides the accounts’ payable dates irrespective of the due date. Accounts receivable are the blood of the business because it needs money to run. Source: Accounting Templates in Excel () #4 – Accounts Receivable TemplateĪccounts receivable is just the opposite of accounts payable. We need to enter the payee’s name, invoice date and amount, due date, and TDS percentage.Įvery vendor requires different TDS percentages, so one must enter the TDS percentage based on the vendor category. This Excel template is unlike our cash book, where we had two parts for recording debit and credit transactions.Īccounts payable are all the payments companies require to payout to their vendors to receive goods and services. In the “Cr” column, we need to enter all the inflow transactions. We need to enter all outflow transaction amounts in the “Dr” column. You are free to use this image on your website, templates, etc., Please provide us with an attribution link How to Provide Attribution? Article Link to be Hyperlinked We can see slightly different columns compared to the previous cash book ledger. ![]() Petty cash is used to maintain all the daily expenses to fit daily business needs.ĭaily expenses are printing and stationery, postage and courier, repair and maintenance, and office expenses. #2 – Petty Cashbook TemplateĪnother simple cashbook template important for small businesses is Petty Cashbook. So, cell D14 has a total balance available, i.e., Credit Total – Debit Total. Then, we can get the debit total and credit total. Then we need to enter the transaction details, and the final part is to enter the transaction amount. First, we need to enter the date of the transaction. For both debit and credit transactions, we can see three standard columns.
0 Comments
Leave a Reply. |