Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
April 18, 2026
Question

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

  • April 18, 2026
  • 1 reply
  • 2 views

how do i fix it.

1 reply

April 18, 2026

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.