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 […]
In this article, we will discuss the Traditional IRA Calculator which will be helpful to you to decide the amount of savings you need to invest for your retirement goals. IRA stands for Individual Retirement Account. A Traditional IRA is a type individual retirement account. Investing in traditional IRA helps you grow your earnings tax-deferred. In […]
In this article, we will discuss the Roth IRA Calculator. This calculator helps you to decide the amount of contribution amount you need to put in Roth IRA to achieve your retirement goals. In our previous article, we have discussed the Traditional IRA Calculator. As we know, IRA stands for Individual Retirement Account. A Roth […]
AGI or Adjusted Gross Income Calculator helps you calculate define your tax bracket as well as your tax liability. AGI is is the basis of several tax thresholds. It also helps to determine the eligibility for certain tax credits. AGI is your total income less of allowable deductions. We have created an easy and ready to use Adjusted […]
Modified Adjusted Gross Income Calculator is an excel sheet which helps you calculate your MAGI very easily and accurately. MAGI is calculated by adding back several deductions to your AGI – Adjusted Gross Income. Usually, MAGI is useful for determining the eligibility of Roth IRA Contributions as well as other IRA deductions. Several tax credits […]