How to split a bank statement line to multiple accounts

Summary

How to split a single statement line over multiple ledger accounts in Sage Accounting.

Description

You can split a single bank statement line across multiple ledger accounts before creating a transaction using Bank Feeds or importing a statement. For example, if a credit card payment at a gas station includes fuel and food, you can split that one transaction into separate ledger accounts.

If you use analysis types, select different analysis categories for departments, cost centers, or projects. Specify different tax rates if required.

  • You can split other payment or receipt transactions, but not Payment on Account transactions
  • You can’t split transactions across different customers or vendors

Resolution

  1. Download or import your bank statement.
  2. Click Split Transaction next to the relevant transaction.
  3. Enter the following details:
Description Enter a description, if needed.
What Select the relevant ledger account from the drop-down menu.
Department / Cost Center / Project Select the appropriate analysis category if you have set up analysis types.
Tax rate Select the applicable tax rate if you have configured tax rates.
Total Enter the amount.
  1. Repeat the entry for each split line. Ensure the total of all lines matches the statement line value. The difference must equal zero.

    •  

      To cancel the split, click Cancel Split
    • To finalize the transaction, click Create

Solution Properties

Solution ID
240304191719097
Last Modified Date
Mon Mar 04 19:17:19 UTC 2024
Views
0