HOME / COMMUNITY Switch to knowledge base

Accounting for daily takings


#1

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 Streamline card services.

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.


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
Weekly Takings & Invoices - Crossing Over Periods
Braintree vs Stripe
Entering the information from receipt book takes an age, does it have to
Limited Company Bookkeeping - The Basics
Cash Deposit into Bank
Cash Takings
Purchase Payment is Currently Unallocated
E-commerce invoicing
Non invoice sales
Importing sales invoices to the correct client accounts and future proofing for use of APIs
Am i Bank Transfering Correctly?
Ebay records
Can I collate all payments from a source monthly?
Can this be used for a B&B?
Invoices for donations and multiple customers with no data
Using QuickFile for an eBay Dropshipping business
Tagging sales transactions
PayPal automatically pull in historic data
Linking receipts in the hub to bank statements
Just Starting Out - HELP!
New Cash Register Tool
Making Tax Digital (importing via CSV)
Joomla Shop Integration?
Import invoices
Importing Invoices with items that have different VAT rates
Stripe payments from another system - how should they be recorded?
Uploading invoices
Multi-line invoice importing
Lots of small retail payments into bank account