How to split one amount into QuickBooks Credit and Debit

Task

A bank table has one amount column: incoming payments are positive and expenses are negative. QuickBooks needs separate Credit and Debit columns.

Short answer

Create Credit only for amounts above zero, Debit only for amounts below zero, and remove the minus sign from Debit.

How to do it in Eofferix

Upload the bank table and open the table editor.
The preview shows the positive amount in Credit and negative amounts in Debit without a minus sign.
Create Credit from amount and add a rule: if amount is less than or equal to 0, do not load the field.
Credit is not loaded when the source amount is not positive.
Create Debit from amount: if amount is greater than or equal to 0, do not load the field; then remove -.
Keep date and description as separate columns and save the template.

Before / after

The data below is a training example and does not belong to real user files.

Before

source data

date	description	amount
2026-06-01	Client payment	1250.00
2026-06-02	Bank fee	-15.00
2026-06-03	Refund	-49.50

After

result

date	description	Credit	Debit
2026-06-01	Client payment	1250.00
2026-06-02	Bank fee		15.00
2026-06-03	Refund		49.50

How to split one amount into QuickBooks Credit and Debit

How to do it in Eofferix

Before / after

Before

After

Process data faster with Eofferix