Skip to main content
April 6, 2020
Question

How to record this awkward series of transactions

  • April 6, 2020
  • 1 reply
  • 0 views

We have one main account.

This has two sub accounts, "current" and "client" as we hold money from clients on behalf of our performers.

 

Our transactions are roughly as follows:

 

Client pays us £50 in to client account.

 

We pay the performer for the event £45 and keep £5 commission.

 

We need to pay them from the client account and then transfer the £5 to ourselves.

 

Could someone please walk me through the steps for doing this as I am struggling to get everything to match up. The main sticking point is that we need to raise a bill from the performer of £50 and then a sales receipt/invoice for £5 but the physical transaction from us to them is just the difference (£45) which is causing all sorts of headaches (primarily because I can't seem to match a transaction in our bank feed to both an invoice AND a bill and I can't split it either because it needs to affect two separate (sub) bank accounts). This also means I'm having to exclude all the performer transactions from our bank transaction list which just seems wrong.

 

Also, trying to transfer money between "client" and "current" just results in both a deposit and a payment of £5 inside both accounts.

 

Any advice very welcome. This really doesn't like it should be as hard as it is.

 

1 reply

Adrian_A
April 7, 2020

Thanks for the details, jgelectrical.

 

We can use the Project feature in QuickBooks to record these transactions.

 

Just a heads up, It would be best to reach out to your accountant. They're the best support that can decide on what's the best way to do this.

 

The Project feature helps us to track a project's income, expense, and profitability. Before creating a project, we'll have to turn this option first. I'll show you how:

 

  1. Click the Gear icon ⚙, and then select Account and Settings.
  2. Go to the Advanced tab.
  3. Find the Projects section and click the pencil (edit) icon.
  4. Select the Organise all job-related activity in one place checkbox.
  5. Select Save and close your settings.

 

Once turned on, you're good to create a project.

 

Feel free to get in touch with me if there's anything that I can help. Stay well!