![]() The summary section consists of a summary of the total transactions. The header section consists of Company name, template title, and logo.Įnter the opening balance manually. We have created a ready-to-use Cash Book With Discount Template which helps you chronologically easily record and reconcile cash transactions with discounts.Įxcel Google Sheets Open Office Calc Contents of Cash Book Template With Discount In the end, the total of the amount column for both Debit and Credit side is given using the SUM Function. To record a transaction, insert date, Particular, Amounts on Debit/Inward, or Credit/Outward side. Both sides consist of 3 columns each: Date, Particulars, and Amount. The formula applied here is the total of Debit/Inward – the total of Credit/Outward =(C21-F21). The Cash on Hand balance amount is displayed on the right-hand side. The first row is for the company name and second for the title of the template. Important Note: To edit and customize the Google Sheet, save the file on your Google Drive by using the “Make a Copy” option from the File menu. We have created a ready-to-use Simple Cash Book Template which helps you to easily record and reconcile your cash transactions.Ĭlick here to Download All Accounting Excel Templates for ₹299. The functioning and formulation are the same in all three formats. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |