How to split a transaction for commission or fees deducted

This article explains how to record in FreeAgent if you receive an amount of money that's already had bank charges, payment processor charges, currency charges, commission, fees or subcontractor's CIS tax deducted.

It's fairly simple to split a transaction between more than one category in FreeAgent, though you may need to start by setting up one or more new categories.

But what happens if you receive an amount of money that's already had bank charges, fees from a payment processor such as PayPal, GoCardless, Stripe, Dwolla or SumUp, currency charges or commission deducted?

CIS Deductions for Subcontractors would be split when creating the invoice.

Here's an example.

Customer paying net of payment processor charges

You've charged your customer £126, but the money that comes into your bank account for that sale is only £100 because your customer pays you through a payment processor, who deducts charges.

So, how do you record that receipt so that you account for the charges and don't have your customer's account (if you created an invoice for that sale) amount permanently looking as though that customer still owes you £26? By splitting the Money In transaction.

1. Increase the amount of money received 

Navigate to the 'Banking' tab at the top of the screen and select 'Bank Accounts' from the drop-down menu.

Screenshot showing the 'Banking' menu with 'Bank Accounts' highlighted

Choose the relevant bank account from the list of accounts.

Screenshot_2022-10-28_at_14.57.43.png

Select the transaction, then choose 'More Options (alternatively, you can hold down the 'alt' key on your keyboard while you select the transaction) to access the 'Explain a transaction' screen.

If you created an invoice for this sale, you would explain the transaction with type 'Invoice Receipt'. If you did not create an invoice, you would explain the transaction with type 'Sales'. You would then change the amount to the full amount of the sale. So in this example, you would change the amount from £100...

mceclip0.png

...to £126.

mceclip1.png

Finish explaining the transaction as normal, choosing the correct invoice (if applicable) from the unpaid ones.

Select New Explanation.

2. FreeAgent automatically adds a new payment for the deduction

You'll see that FreeAgent has now put a new payment of £26 in, to ensure the running total in the ban is correct.

mceclip2.png

You now need to explain this as the deduction, which might be bank charges, commission paid, or CIS tax deducted. 

In this example, you would explain the £26 as bank charges, which is a type Payment and is in the Bank/Finance Charges category.

Screenshot_2020-12-09_at_20.41.14.png

You would then explain the rest of the transaction as normal and then save it.

Did you find this article useful?