cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
accounts665
Level 1

good day, i import bank transactions, payments went to receipts and debtors to payments

how do i fix it.

1 Comment 1
ClarenceCort_B
QuickBooks Team

good day, i import bank transactions, payments went to receipts and debtors to payments

Hi there, @accounts665. To fix your imported transactions that were mapped incorrectly, go to Bank Transactions > Posted. Select the wrong transactions, click Undo to move them back to the Pending tab, then Exclude them so they don’t affect your accounts.

Next, check your CSV to ensure it uses either the 3-column (Date, Description, Amount) or 4-column (Date, Description, Credit, Debit) format and that all amounts are in the correct columns. Then go to Bank Transactions, select Upload from file, and map the columns correctly.

Following these steps will ensure your payments and receipts are recorded accurately in QuickBooks.

For detailed guidance on correct mapping, refer to this article: Format CSV files in Excel to get bank transactions into QuickBooks.

If you have any further questions or need assistance with QuickBooks, feel free to click the Reply button.