The Book-keepers Forum (BKF)

Post Info TOPIC: Quickbook Online and Just Eat Book Keeping


Newbie

Status: Offline
Posts: 1
Date:
Quickbook Online and Just Eat Book Keeping


Hi,

I am not a qualified accountant but can do basic book keeping. I am new to OBO. I have the following query and I am hoping you can help as I have googled lots!

My partner runs a takeaway and uses Just Eat to fulfil orders. Each week we receive an invoice from Just Eat. I have set up Just Eat as a Customer and in the Chart of Accounts I have set up Just Eat as an Income Account (sub account under Sales), Just Eat Fees as an Expense account

The invoice has the following items: Total Sales, Card Sales, Cash Sales, Commission. Each week the Cash Sales, Commission are deducted from the invoice (as our driver collects the cash) and the remaining is then deposited into my Bank Account. VAT is charged on Commission.

I am struggling as to how to add this into QBO. This is what I did:

1. I set up the following products:

- Card Sales

- Cash Sales

- Commission

2. I then create a Sales Receipt where I add all three products above and I place a -ve amount +VAT for the Commission

I have the following issue, this amount doesn't match the amount that is deposited in the bank (because it includes the Cash Sales).

How do I account for the cash sales that are in the Cash Register. I have created a Cash Register Bank Account, but it seems like the Sales Receipt only lets me direct these products to ONE bank account.

Also we are not VAT registered at the moment (as we are new and below the threshold) so for income should I put "No VAT" or "Zero VAT" and tick 'amounts are exclusive of Tax' on the overal receipt. But then how do I mark the Commissions which do have VAT.

I was hoping I could do this all in one transaction, but it seems like I will have to create separate ones - especially for the cash?

Your help is very much appreciated



__________________


Master Book-keeper

Status: Offline
Posts: 3786
Date:

Hi Reena

I'm not familiar with QB (just taken on a new client who is using it, so I'm likely to get acquainted soon) but the accounting entries should be as follows.

When doing the JE invoices don't record the cash, just the card sales. Record your daily cash takings into the cash account as you get them. Total commission including VAT can be recorded on the expense, VAT doesn't need a separate entry until you are VAT registered. That should simplify it hopefully, and it should balance.

I would also suggest looking to take on an external accountant at the start of your business, rather than when the accounts are due. It gives you a chance to get to know each other and is on hand for tax advice. Most accountants will let you pay monthly towards the first years fees so it's not a sudden hit at the end.



__________________

John

Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Member

Status: Offline
Posts: 7
Date:

Hi Reena,
You might find the 'Undeposited Funds' option on QBO useful to record the daily Sales by card and cash.
Then you can use the 'Find Match' when the payment shows up in your bank. The commission fees can then be added at this point.
Hope this helps.

__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
2007-2021 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: info@bookcert.co.uk.

Privacy & Cookie Policy  About