#Simple accounting for small business in excel download#

Click on the icon button to download the desired format. Let us understand the content o each template in detail.ДЇurthermore, all these templates are available in 3 file formats вЂ“ Excel, Google Sheets, and Open Office Calc. We have created ready-to-use excel templates with predefined formulas for each type of Cash Book. This type of book consists of additional columns for Discounts and Tax. Triple Column Cash Book (Discounts and Tax)Д¬ash Book with Discounts and VAT is for those whose daily cash transactions include giving/taking of discounts and also collecting or paying taxes. If there is any other tax applicable in your area, you can insert it according to your needs. This can be either GST (Goods and Service Tax) or VAT (Value Added Tax). Similar to the simple cash book, it also consists of a debit and credit side along with an extra column for tax. It consists of an additional column for discounts received or paid. Thus, these type of businesses maintains Cash Book with Discounts. Some businesses have to provide discounts during their cash transactions. Single Column cash book is a document which records inward and outward cash transaction of a business without any discounts or tax. It is a subsidiary as well as a principal book of accounting.The cash column cannot have a credit balance.It records transactions in chronological order.Cash Book records only Cash & Bank transactions.

Record all the receipts cash on the debit side and all payments and expenses on the credit side of the cash book. This helps us to easily reconcile the cash balances when required. The records fed in the cash book are always in chronological order. In a smaller business as there are fewer transactions, such businesses maintain all the cash transactions a single cash book. One is the receipt Journal and the other is the disbursement journal. In big companies where there are high volumes of cash transactions, the cash book is subdivided into two different journals. You can use our Bank Reconciliation Statement Excel Template for this purpose. The best-known practice of business is to weekly compare the bank related transaction with the bank statement or perform a bank reconciliation to avoid mismatch of balances. At the end of the month, the accountant posts these transactions to the general ledger. It is a subsidiary ledger that records all kind cash receipts and cash payments including bank deposits and withdrawals. There is no need to open a separate cash account in the ledger. Cash Book Template With Discount and TaxД¬ash Book records of cash transactions done in a company on a day to day or regular basis.Cash Book Template With Tax (VAT/GST/Sales Tax).Triple Column Cash Book (Discounts and Tax).