How to split a bank transaction between two categories
This article explains how to break down a bank transaction that needs to be explained partly into one category and partly into another.
For example, a single purchase may include box files that need to be explained to ‘Stationery’ and a book of stamps that needs to be explained to ‘Postage’.
If you're registered for VAT, it’s important to allocate the relevant amount to each category and apply the appropriate VAT rates if they differ between the categories. If both the categories you'll be using have VAT on them, then you need to apportion the VAT between them. If only one category has VAT then all the VAT on the receipt would go into that category.
Begin by navigating to the 'Banking' tab at the top of the screen and select 'Bank Accounts' from the drop-down menu.
Choose the relevant bank account from the list.
Select the transaction that you would like to explain.
2. Split the bank transaction
Next, you will need to split the bank transaction into the relevant amounts for each category.
To do this, select ‘More Options’ in the bottom-right corner. Alternatively, you can press the 'Alt' key or ‘Option’ key, depending on your device, at the same time as selecting a bank transaction to open ‘More Options’.
Enter the amount that you would like to allocate to the first category in the ‘Value’ field and select the appropriate VAT rate using the ‘VAT’ drop-down menu. To allocate a certain amount of VAT to the transaction, select ‘Amount’ from the ‘VAT’ drop-down menu and enter the appropriate amount.
Select the relevant category to allocate this amount to using the ‘Category’ drop-down menu and enter a description to help you identify what the transaction relates to.
Select ‘Create New Explanation’ at the bottom of the screen to explain the amount to the first category.
3. Explain the remaining balance
Next, you will need to explain and categorise the remaining balance of the bank transaction. You will notice that FreeAgent has created a new transaction for the remaining amount to be explained. In the above example, we’ve explained £15 of the original £30, so FreeAgent has created a new transaction for the remaining £15.
To explain the remaining balance between multiple categories, select the new transaction, select ‘More Options’ and follow the steps above to split the transaction again.
To explain the remaining balance to a single category, select the new transaction, then select the relevant type from the ‘Type’ drop-down menu and select the relevant VAT rate from the ‘Including’ drop-down menu. To allocate a certain amount of VAT to the transaction, select ‘Amount’ from the ‘VAT’ drop-down menu and enter the appropriate amount.
Select the relevant category to allocate the remaining balance to using the ‘Category’ drop-down menu and enter a description to identify what the transaction relates to.
Select ‘Explain Transaction’ to complete the process and split the value of the bank transaction between two categories.
A record of the bank transactions having been explained will appear in your Audit Trail report.
FreeAgent is registered with the Financial Conduct Authority under the Payment Services Regulations 2017 (register no. 799763) for the provision of account information services.
Registered in sunny Scotland No. SC316774 - One Edinburgh Quay, 133 Fountainbridge, Edinburgh, Scotland, UK EH3 9QG