It consists of an additional column for discounts received or paid. Similar to the simple cash book, it also consists of a debit and credit side along with an extra column for tax. If there is any other tax applicable in your area, you can insert it according to your needs. This type of book consists of additional columns for Discounts and Tax. We have created ready-to-use excel templates with predefined formulas for each type of Cash Book.
Let us understand the content o each template in detail. Click on the icon button to download the desired format. The functioning and formulation are the same in all three formats. We have created a ready-to-use Simple Cash Book Template which helps you to easily record and reconcile your cash transactions.
The first row is for the company name and second for the title of the template. The Cash on Hand balance amount is displayed on the right-hand side. There are 2 sides Debit and Credit. Both sides consist of 3 columns each: Date, Particulars, and Amount. We have created a ready-to-use Cash Book With Discount Template which helps you chronologically easily record and reconcile cash transactions with discounts.
Enter the opening balance manually. The summary section consists of a summary of the total transactions. It will display the opening balance, current income after deducting discounts, current expenditure amount after the discounts.
It will also display the amounts of discounts received and discounts given on total transactions. The data entry section has 2 sides, debit, and credit. Both the sides consist of the following 5 columns:. The last line consists of totals of the amount and a discount column for ready reference.
These amounts also reflect in the summary section. Furthermore, it generates transaction wise and tax percentage-wise reports in a few clicks. A value-added tax VAT is a type of general consumption tax that is collected incrementally, based on the value-added, at each stage of production. In some countries, it is known as goods and services tax. The VAT is ultimately paid by the end consumer.
Dealers collect VAT on their sales, retain the tax paid on their purchases. The balance of VAT is paid to the Government. Thus, all the above computations are linked to the cell showing totals of the respective head in the table.
This section has 2 parts; incomes and expenditures. You can either keep this in electronic form on your smartphone or buy it as a bound booklet from a specialist office retailer. However, there is nothing stopping you from creating your own logbook. Our mileage log sample will help you with this. As an entrepreneur, you should have basic knowledge of double-entry bookkeeping with debits and credits Here's a list of tips on how to write a quote and the correct way to structure it Who has to keep a cash book?
Download the cash book template If you decide to keep a cash book, you can download a free cash book template from us in the Digital Guide. Cash book template for Excel Download.
The following information is recorded in six columns: Date of the transaction Receipt number for clearly assigning the document to the transaction Booking text short description of the transaction Receipt and currency of the cash revenue or expenditure Applied tax rate sales tax Current cash balance and debit balance In the header of the cash book template, there are two additional fields: one to enter the name of your company , and another for recording the time during which the respective cash book sheet was kept.
Then make the initial entry for the time : If you want to start the cash book on the same day, note the current date. If you want to fill out the cash book sheet over multiple days more likely to occur in exceptional cases , then enter the end date when the sheet is filled out. This way, you avoid incorrect entries. The next step is to transfer the current cash balance into the table. By the following day at the latest , you must enter all payments into the cash book template. Under the table, on the right, the sum of incomes and expenditures is entered and the balance is calculated.
Before you print out the cash book sheet, make sure once again that all values are correctly entered so that the final entry can be calculated without errors. This will be transferred as the starting balance on the next sheet. In general, you should print out the cash book sheet at the end of every day. Check first to see whether the complete period of the document has been specified correctly in the header. You can attach your signature to the printed document and file it chronologically with your other records.
You can also save the sheets as PDFs. On the next day, start a new cash book sheet with the saved template. Click here for important legal disclaimers. Related products. View packages. Popular Articles Debit and credit definition As an entrepreneur, you should have basic knowledge of double-entry bookkeeping with debits and credits This excel bookkeeping template is a cash book specifically for tracking income and expenses off a credit card.
Go to Expense Form Template This template is similar to the cash book but it includes sales tax features and the tracking of two bank accounts and one credit card.
Go to Accounting Excel Template Need to give your customers a sales invoice? Excel already has a great variety of Invoice templates included in their system. The same goes with just about any other template that you might need. You probably don't need to search the web or use my templates to find one - just look inside Excel! I have done a sample invoice anyway and you can click on the link to go look at it and use it to get an idea of what information you need to include on your self-designed template.
Go to sales invoice This is what you need to send to your customers at the end of the month. Use it to list all the invoices you have sent them and include a total. This tells your customers how much they owe you, and if for some reason they are missing an invoice, they can contact you for a copy. Go to Statement Use this spreadsheet to record all the invoices a business issues to a customer who have an account with the business.
You can track customer payments, and keep notes on what a customer says if the business has to call them about overdue payments. Go to Accounts Receivable Ledger. If you buy or make stock items and sell them, you can use this Excel inventory template to keep a track of all items purchased made and sold, having a record of the costs and prices, the quantities, the values and so one for each one.
There is an overall Inventory Report which updates automatically so you get to see the totals in one list and immediately see the quantities left in stock, and the overall value of stock on hand.
Go to Excel Inventory Template. Although this particular excel receipt is geared towards rent, you can easily customize it to exclude anything to do with rent if you require a receipt for other purposes.
This template has two versions, one has a shaded background which just makes it look pretty, the other one has no shading so saves the ink usage on your printer. Go to Receipts This spreadsheet is a fantastic tool for keeping a record of your purchase invoices due for payment.
You would not use this spreadsheet if you paid for your goods at the time of purchase - eg. Go to Accounts Payable Ledger.
This particular cash flow report is good to use if your business is tight on funds and you can only pay bills as income comes in.
0コメント