Pub Accounts

Just bringing some accounts up to date for a pub client. They are of course primarily cash based. Sales charged through the till and receipts provided daily to show takings. I've reconciled the bank account and accounted for all of the credit/debit card transactions that have come through to the bank account and I'm now looking at preparing the VAT return. However, there is a bulk of transactions that although processed via credit card, have not yet reached the bank. Just thinking about the best classification for these as it's cash in transit effectively but it's not in the bank so can't be recorded there, it's not debtors because it has actually been paid and it's not cash. It's a current asset but not sure which category it should be included in the statutory accounts.

On a different  note, accounting for the sales has been a nightmare. Lots of daily transactions and although they've provided a daily till receipt summary there is no VAT breakdown. Copied the figures into a spreadsheet to breakdown the VAT. Also, added columns to reflect how payment was made, mainly by card. However, the credit card merchant provides a monthly statement and the daily amounts very rarely agree to the till credit card takings due to timing differences. The amounts also appear in varying batches on the bank statement and don't necessarily hit the bank statement as the same amounts on the credit card merchant statement. I'm essentially accounting for sales as per the banked amounts and any balance from the monthly sales which hasn't been banked is either cash held by the client or payments still in transit.

Any thoughts welcome on how the cash in transit should be reflected in the statutory accounts would be welcome.

Comments

Bank?

Anonymous | | Permalink

How about just debiting the bank? Adjust for any changes when the amounts are confirmed in the bank.

pawncob's picture

Tracking

pawncob | | Permalink

They should be treated as debtors, because they haven't hit the bank account yet. Keep  track of them at the year end so they don't get mixed up with any normal debtors.

If sales are recorded on an actual basis, make sure they're not included twice.

how about unpresented bank transactions?

Anonymous | | Permalink

Like unpresented cheques - the event has actually happened i.e. the sale has been made - its just not been processed by the bank yet. If you treat them in this way there is no chance of getting the sales in twice.

Chris Smail's picture

Change the cut off time on the pdf system

Chris Smail | | Permalink

We found this out the hard way too.

The card reader system has an 'end of day' procedure which is set at a time in the system, this setting can be altered. We had a pub where the machine was set to 8pm which caused chaos until we got it altered to match the till system. Then the bankings for the day on the till system tied straight in to the bank.

I treat the card takings as unpresented lodgements if not too numerous. If the volumes justify it I use a seperate bank account for them, post the main account receipts as inter bank transfers and reconcile the account using the card prints.

Till report

Anonymous | | Permalink

the daily Z and other reports from the till are most useful

you should complete a balanced cash sheet  daily takings Z [ by category for accounting breakdown is v useful ] incl VAT  less till cash payments[possibly with vat? ]  - less cash received [ over float ] - less credit card = nil  in theory

way to ensure cash "theft" + non receipted spends, and other transactions are reviewed and reconciled

ie debtors ,  being bar bill not paid !!!!!   part of sales but not in cash/cards   or not ringing sales means too much cash'n'cards @ end of day.  either way issues are seen daily

best way to treat c/c is to set up another bank account for each and on receipt at BANK transfer into main account from in transit c/card.  this means you can control the chargebacks, and those which may not be remitted which IS FREQUENT !

 

if you want to discuss off line

ar_rcl [ at ] hotmail.co.uk

Credit card payments

Rebrovsky | | Permalink

These should be treated as bankings. As someone else said, they are the same as late credits (cheques that have been banked but not cleared)

They form a part of the cahsbook balance and therefore the bank balance in the customers account on the day that the payment has taken and then are a reconciling item between the bank statement and the cashbook.