Skip to main content

How do I split a transaction for accounting sync to QuickBooks / Xero?

Written by Taylor Morgan

How do I split a transaction?

On the Accounting page, open any transaction that hasn't been synced or excluded yet and choose Split transaction. Add a line for each component, with a description and an amount. The sum of all the lines must equal the original transaction amount before you can save — Venn will block submission until it adds up.

Can each line have its own category, tax rate, and class?

Yes. Once you've saved the split, each line is categorized independently. You can set a different accounting category, class, location, tax rate, vendor, customer, and bill for each one. For example, you can mark one line as a tip with no tax, and the main line as a meal with the appropriate tax rate.

What gets sent to my accounting system?

Each line is synced to QuickBooks or Xero as its own entry. If you split a transfer into two bill payments, you'll see two separate bills in QBO, each marked as paid. If you split a transaction to separate out the tip, you'll see two separate expense lines. The original transaction in Venn stays as the parent reference.

Can I edit a split after I create it?

Yes. Open the parent transaction and you can add new lines, change existing amounts and descriptions, or remove lines. The total must still equal the original transaction amount.

Can I undo a split?

Yes. Open the transaction and choose Remove split. This removes all the child lines and reverts the transaction to a single, uncategorized line, ready to be categorized normally.

Can I split a transaction after it's been synced?

No. Once a transaction is synced or excluded, it's locked. If you need to recategorize a synced transaction, make the adjustment directly in your accounting system.

How are Venn fees handled now?

When a transfer has a Venn fee on it, the transaction is automatically split into the net amount and the fee — the fee line is pre-coded to your bank charges account and ready to sync.

Can I change or remove the fee line?

No. The fee line on a transfer is fixed — you can't edit the amount or delete it. You can still add other lines around it if you want to further split the rest of the transfer (e.g. splitting the non-fee portion across two bill payments while the fee stays as bank charges).

Can I change the account a fee is booked to?

The fee line is automatically posted to your bank charges account.

Who can split transactions?

Anyone who is allowed to access and edit accounting tab. That's typically your Owner, Admin, Accountant, and AP Clerk roles. Employees cannot split transactions.

Do I need to turn this on?

No setup needed. The feature is available to all businesses on all plans.

I split a transaction and now the categorization on the original is gone?

This is expected. When a transaction is split, any categorization on the parent (account, tax, vendor, invoice, customer, bill) is cleared, because categorization moves to the child lines. The customer should categorize each line independently.

Did this answer your question?