Skip to main content
P
PVH1
October 30, 2021
Question

Correction value in Bank CSV upload

  • October 30, 2021
  • 1 reply
  • 0 views

Hi,

We uploaded a series of (older) banktransactions with a CSV extracted from our banking platform.

We didn't notice that Excel mis-interpreted one of the values (1000 instead of 10).

How can we correct this value in QBO? (we don't want to reverse the upload)  How would this journal entry look like?

Many thanks up front!

 

1 reply

Angelyn_T
Angelyn_T
October 30, 2021

Hi there, @PVH1. I can help you with getting the correct values of your older bank transactions.

 

Once the transactions are uploaded into QuickBooks Online (QBO), you won't be able to modify the amount from the Banking page. The workaround is to exclude the entries from there, then reupload the transactions. Please make sure that the file contains the correct values before bringing them to QuickBooks.

 

If you don't want to reverse the upload and use journal entries to offset the amounts, I would recommend seeking assistance from your accountant to keep track of your balances and pick the correct debit and credit accounts.

 

To record journal entries:

 

  1. Go to the +New icon, then click Journal Entry.
  2. Fill in the information.
  3. Save the transaction.

 

Now that your transactions are corrected, it's time to match and categorize them. The transactions go into your accounts after you review them.

 

If you have any other follow-up questions about your bank CSV upload, let me know by adding a comment below. I'm more than happy to help. Wishing you a good one!

Terms & ConditionsAccessibility statement