What is Accounts Payable? As per Wiki Accounts payable is money owed by a business to its suppliers shown as a liability on a company’s balance sheet. It is distinct from notes payable liabilities, which are debts created by formal legal instrument documents. Or in very simple terms accounts payable ledger consists of the list […]
Download Free Accounting Templates in Excel
Want to manage financial records of your company or clients? Now you can use MS Excel to manage complete financial records such as invoice, profit and loss statements, generate salary slips, prepare balance sheet, track accounts payable and receivable etc.
All excel templates are free to download and use. Click the link to visit the page to find the detail description about each template and understand how each template has been prepared.
If you didn't find any accounting template here, please use of our suggestion form.
What is Accounts Receivable? As per Wiki Accounts receivable is a legally enforceable claim for payment held by a business for goods supplied and/or services rendered that customers/clients have ordered but not paid for. These are generally in the form of invoices raised by a business and delivered to the customer for payment within an […]
What is a Cash Book? Cash book is the record of cash transaction done in a company on a day to day or regular basis. Cash book is just like a ledger account. There is no need to open a separate cash account in the ledger. The balance of cash book is directly posted to […]
Invoice is a document issued by a seller to the buyer for a transaction. It consists of details of services or goods supplied along with rates of services provided or per unit price of goods. An Invoice is issued to the receiver of goods or services for payment, and the record is maintained in accounts […]
An expense report template is a very useful document to keep track of business expenses for an employee’s business trip, a particular department, or any project for a company. It provides a quick track of expenses and relevant documentation. This template can be used for reimbursement purpose for business trips or expense tracking and can […]
A Petty Cash Book is a document in which all petty or small daily routine payments made from petty cash fund are systematically recorded. In other words, Petty Cash Book is a type of Cash Book which is generally maintained in large businesses to reduce the burden of ‘Main Cash Book’. Petty Cash Book can […]
Inventory Control template is a document that keeps track of products purchased and sold by a business. It also contains information such amount in stock, unit price, and stock value etc. Furthermore, while preparing Profit and Loss Accounts for a company we require the cost of Inventory. This is also be derived using Inventory Control […]
Billing Statement Template is a document that is used to track invoices, accounting details, and billing status etc, all in one location. In other words, amount to be collected against goods or services sold on a credit basis for a particular customer are recorded in this statement. Our Billing Statement Template consists of Accounts Receivable […]
Purchase Return Book is a subsidiary book of accounts which records the goods returned to our suppliers. It is also called return outward book. Usually, when poor quality, inaccurate quantity, untimely delivery goods are received, we return those goods to the suppliers. Purchases returns or returns outwards, are a normal part of the business. You need to […]
Accounts Payable Template is a document which records invoices of goods purchased by us on credit. No upfront cash is paid. In other words, our creditors whom we are liable to pay them during a specific time. All kind of Payable is the liability for any company and is recorded in the current liabilities section. […]
Accounts Receivable Template is a document which records sale of services or goods by a company made on credit. In other words, Account receivable Ledger records the credit invoices of a company to its debtors. These receivables are our assets. Accounts receivable is listed as a current asset on the seller’s balance sheet. The total amount […]
A Budget Template is a quantitative expression of a financial plan of a company or individual for a defined period of time. It includes estimated sales volumes and other revenues, expenses and cash flows. In other words, a budget is the allocated amount for a particular business purpose and the summary of intended expenditures. Thus, […]
A Cash Book Template is a document which contains all cash receipts and payments, including bank deposits and withdrawals. In simple terms, Cash book is a book of entry which records all the transactions pertaining to cash receipts and payments in chronological order. Business systems have changed in recent years. Many taxes have been introduced […]
A Checkbook register is a very useful document for keeping track of your Bank balances for personal and business accounts. The Checkbook Register is crucial document to remain on top of your financials. It helps you to look where the money is coming/going from and how much is left with you. Many a time, it […]
This article contains the Personal Budget Excel Template with graphs and predefined formulas. This Budget is for individuals. For Company Budget please click here. A personal budget is a financial plan that allocates your personal income towards routine expenses eventually helping to do savings or debt repayments. Budgeting is similar to dieting. During a dieting, […]
As per Wiki, A purchase order (PO) is a commercial document and first official offer issued by a buyer to a seller, indicating types, quantities, and agreed prices for products or services. It is a buyer-generated document which states the requirements and serves as a legal document authoring a purchase transaction. A purchase order describes […]