Accounting for daily takings

Please Note: From 19th January 2017 we have introduced a new tool for logging cash register sales (see here for details). This guide will explain the manual method which remains useful for more complex scenarios, e.g. where you wish to differentiate product lines.

Not all businesses provide invoicing facilities to their customers. Many shops, garages, restaurants, and retail businesses simply operate on a cash basis using a till and issuing customers with a sales receipt. How do we correctly account for these scenarios using QuickFile? Obviously it’s not feasible to enter every single invoice in QuickFile, therefore we would suggest you invoice on a daily basis to reflect the aggregate totals for that day. You can ofcourse log your takings on a weekly or even monthly invoice depending on the level of reporting required.

When logging your invoice we would recommend creating a client called ‘Till sales’ or ‘Daily takings’. You can also create separate clients to differentiate cash and card sales, or any other payment methods for that matter, again it all depends on the level of reporting required.

Let’s start with a simple scenario. Maurine’s Cozy Cafe took £440 in sales on Monday. The business is VAT registered and Maurine is charging VAT to her customers who are eating in the cafe, this equates to £240 of VAT inclusive sales, the remaining £200 relates to take-away sales.

At the end of the day Maurine’s daily takings invoice will look something like this:

You can further categorise your daily invoices by posting subtotals to specific nominal accounts. You can create your nominal account first in the ‘Chart of Accounts’ screen then allocate a line total to that new account. You just need to click on the grey cogwheel icon () to reveal these options.

You can use the till’s Z report to key in the daily totals.

If you are offering your customers with different methods of payment you will need to account for these when marking the invoice as paid.

Once you have entered the daily takings invoice, click to save and preview. In our example £300 of the daily takings was received in Cash. We can log a payment to reflect the cash into the business:

The remaining £140 was received through card payments. This can be posted to a special bank account we have setup for Square Card Sales.

In this example we are entering the totals for the day based on the Z1 readings from the till. Each Z1 reading should be logged individually as a new invoice, therefore if you take the Z1 reading intermittently, then simply raise a new invoice for each Z1 as of the date taken. We would recommend that you attach the Z1 scanned copy to each invoice.
All the relevant nominal ledgers will track the sales, VAT, and payments relating to your daily sales.

You can also setup a custom report to show your daily sales and payments.

1 Like
Cash Register Tool
Advice on Bookkeeping methods for sole trader
Sole Trader Bookkeeping - The Basics
PayPal How to Tag Appropriately
Welcome to the Knowledge Base
Braintree vs Stripe
Cash Deposit into Bank
Can this be used for a B&B?
Lots of small retail payments into bank account
Weekly Takings & Invoices - Crossing Over Periods
Importing Invoices with items that have different VAT rates
Importing sales invoices to the correct client accounts and future proofing for use of APIs
Non invoice sales
E-commerce invoicing
Import invoices
Purchase Payment is Currently Unallocated
Joomla Shop Integration?
Is there a step by step guide to setting up for Ltd Company
Making Tax Digital (importing via CSV)
Cash Takings
Accounting for takings but do not have same options as in the tutorial screenshots - what setup steps am I missing?
Just Starting Out - HELP!
Limited Company Bookkeeping - The Basics
Cash Register Takings - Goods with VAT and Goods with VAT to Match the Gross
Can someone explain who I add into clients for daily takings?
New Cash Register Tool
Deposit cash to bank account
Linking receipts in the hub to bank statements
Entering the information from receipt book takes an age, does it have to
PayPal automatically pull in historic data
Tagging sales transactions
Using QuickFile for an eBay Dropshipping business
Multi-line invoice importing
Invoices for donations and multiple customers with no data
Uploading invoices
Can I collate all payments from a source monthly?
Stripe payments from another system - how should they be recorded?
Ebay records
Using cash register to record vat and non vat
Am i Bank Transfering Correctly?