Allocate Cash Register Sales

Hi all

Other than creating individual nominal codes for different “branches”, is there another way anyone would recommend (due to the lack of cost centre facility) to put revenue from different sites when completing the Cash Register each day?

The only way I can see I can do it at the moment is enter the full amount, and then go into the sales invoice and then split it out to the appropriate nominal codes for each site according.

Any suggestions would be very welcome.

Many thanks.

What is the source data for your cash register entries? If you’ve got a separate Z reading for each site you could enter each one as a separate cash register entry, possibly with a different dummy client for each site.

Hi Ian

The data comes from an appointment system which does report amounts by site etc.

I do have one dummy customer account that everything goes through. I can do as you say with multiple lines on the one cash register screen, but I cannot select different “customer accounts” in one go. I guess the only way round that would be to just create the individual lines like you say, QF then generates the invoice(s) and after I would need to change the “customer” once submitted.

Many thanks

Ah, I see what you mean. I never really used the cash register tool when I used to run a shop - I’m a programmer by trade so I’d already written a tool of my own to import my Z readings using the QuickFile API before the Cash Register function was introduced. I know you’ve referred in the past to writing your own Python scripts so this might be something you’d be open to trying? If you’ve got a CSV or similar with columns for site name, sales total, VAT total, cash amount & card amount then you could parse that in Python and call Invoice_Create to create one multi-line invoice using a different nominal per line for each site. The Invoice_Create response body includes the InvoiceID which you can then pass to Payment_Create to log the payments against the new invoice for cash and card into the appropriate QuickFile bank accounts.

(I’m happy to share the relevant bits of my code if you want, but it’s in Groovy rather than Python and uses the XML-based version of the API rather than the newer JSON one)

I will definitely look into the Python option, but in worse case I will just do away with the cash register function and go down the old fashioned route and generate one sales invoice and split it into the appropriate nominal codes for each site.

Thanks for your help

Without knowing the exact details, would having each branch as a Sales client work?
You would raise a Sales Invoice then for each Customer (branch).

It could, but the original root of this question was the fact that the “cash register” tool specifically can only be configured with one client for all the invoices it generates.

This topic was automatically closed after 7 days. New replies are no longer allowed.