Import data to general journal

Bunny

I formatted my file in accordance with the sample format but still getting an error, " One or More transactions neither have a credit or debit. The file is attached. A few of the transactions worked but most did not.

Transaction Date,Journal Type,Reference,Description,Accounts Number,Account Description,Debit amount,Credit Amount
2024-01-02,General,GJ1,Deposit by Check,1123,0015: STAR (KK) Taxes Account,-,"-1,393.76"
2024-01-02,General,GJ1,"Withdrawal Transfer To KNOX,KEAUNNA S XXXXXXXXXX Share 0015",1123,0015: STAR (KK) Taxes Account,-,"1,393.76"
2024-01-03,General,GJ1," Deposit Internet Banking Transfer From Share 0027Internet Access 01/03/2024 11:28 119256",1123,0015: STAR (KK) Taxes Account,-,"-2,000.00"
2024-01-03,General,GJ1,Deposit by Check,1123,0015: STAR (KK) Taxes Account,-,"-1,449.50"

borate

Perhaps this will help ... summarized by AI, which is not guaranteed to be 100% accurate...

"One or More transactions neither have a credit or debit."

What's Causing the Error?

This error means that for one or more rows in your import file, both the Debit and Credit fields are blank or zero. NCH Express Accounts expects at least one of these fields to have a non-zero value for each transaction line.

Common Issues in Your File

Looking at your sample:

text

Transaction Date,Journal Type,Reference,Description,Accounts Number,Account Description,Debit amount,Credit Amount 2024-01-02,General,GJ1,Deposit by Check,1123,0015: STAR (KK) Taxes Account,-,"-1,393.76" 2024-01-02,General,GJ1,"Withdrawal Transfer To KNOX,KEAUNNA S XXXXXXXXXX Share 0015",1123,0015: STAR (KK) Taxes Account,-,"1,393.76" 2024-01-03,General,GJ1," Deposit Internet Banking Transfer From Share 0027Internet Access 01/03/2024 11:28 119256",1123,0015: STAR (KK) Taxes Account,-,"-2,000.00" 2024-01-03,General,GJ1,Deposit by Check,1123,0015: STAR (KK) Taxes Account,-,"-1,449.50"

Potential Problems:

Debit Amounts are all empty or "-"
- The Debit amount column has a dash (-) which may not be interpreted as zero by the software.
Credit Amounts have negative values
- Credit and Debit columns should usually be positive numbers. The sign should indicate the direction (debit or credit), not the column.

How to Fix Your File

1. Use Zero, Not Dash

Replace - with 0.00 in the Debit or Credit columns where appropriate.

2. Use Positive Numbers Only

Enter the amount as a positive number in either the Debit or Credit column, not both.
For example:
- If it's a credit, put the amount in the Credit column and 0.00 in Debit.
- If it's a debit, put the amount in the Debit column and 0.00 in Credit.

3. Example of Corrected Rows

text

Transaction Date,Journal Type,Reference,Description,Accounts Number,Account Description,Debit amount,Credit Amount 2024-01-02,General,GJ1,Deposit by Check,1123,0015: STAR (KK) Taxes Account,0.00,1393.76 2024-01-02,General,GJ1,"Withdrawal Transfer To KNOX,KEAUNNA S XXXXXXXXXX Share 0015",1123,0015: STAR (KK) Taxes Account,1393.76,0.00 2024-01-03,General,GJ1,"Deposit Internet Banking Transfer From Share 0027Internet Access 01/03/2024 11:28 119256",1123,0015: STAR (KK) Taxes Account,0.00,2000.00 2024-01-03,General,GJ1,Deposit by Check,1123,0015: STAR (KK) Taxes Account,0.00,1449.50

Pro Tips

No negative numbers in Debit or Credit columns.
No blank or dash values in Debit or Credit columns—use 0.00.
Each row must have at least one non-zero value in Debit or Credit.

Next Steps

Open your CSV in Excel or Google Sheets.
Replace all - with 0.00 in Debit/Credit columns.
Make all amounts positive.
Save and re-import.

If you still get errors, double-check that every row has a value (not blank or dash) in at least one of the Debit or Credit columns.