Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
R
redfoxhauling
January 22, 2022
Question

Manual Upload File Uploaded Amounts Incorrectly

  • January 22, 2022
  • 1 reply
  • 0 views

Hello,

So we changed debit cards in April of last year and didn't realize that our bank account was no longer syncing with Quickbooks. I updated the info and then it started to sync, but only from Sept 2021 onward. 

 

I then downloaded our transaction history from our bank from April - August to upload as a CSV file. I uploaded it, but now that I am going to review the transactions, they are all labeled as debits, all of our credits are negative amounts. 

 

How do I fix this?

 

1 reply

P
Pete_Mc
Level 5
January 22, 2022

I'm not sure why you're trying to download the old data?  Assuming you've been Reconciling your account monthly, QBs will ignore all of the downloaded info as the transactions are already Reconciled.  The Bank Feed will only sync with items that have not already been cleared by a prior Bank Feed or have been reconciled.

 

The Bank Feed is to match and confirm there are no errors in what you've entered into your Register and what the bank actually added or withdrew from your account.  It makes the Reconciliation process a lot faster if you're checking the transactions throughout the month and know that they are correct when you close out the month.

R
redfoxhaulingAuthor
January 22, 2022

Hello, 

 

The problem is that it hasn't been reconciled monthly. We had not data from April 2021- September 2021. When I re-synced the account at the end of this year it only pulled transactions from the last 3 months, there were no transactions from April- September, which is why I manually uploaded the transactions from my bank. 

Rose-A
Rose-A
Level 10
January 22, 2022

Thanks for getting back to us, redfoxhauling.

 

To get this sorted out, you can use the Exclude feature in QuickBooks Online and delete the incorrect transactions. Here are the steps to complete the process:

 

  1. Click Transactions in the left panel and choose Banking.
  2. Select the connected bank account.
  3. From the For Review tab, select all the incorrect transactions.
  4. Tap on the Exclude button.
  5. Go to the Excluded tab, select the transactions again.
  6. Hit the Delete button.

 

After that, you can follow the steps in the following article to import and label them correctly: Manually upload transactions into QuickBooks Online. On the same write-up, you'll find links on how to set up bank rules as well as reconciling your account.

 

Once imported, I recommend editing, assigning, and categorizing your transactions. Also, you can match them to the existing entries in the software. Doing so will help you ensure the accuracy of your financial records.

 

Please know that I'm just a post away should you need anything else. I'm always here to help and ensure that your questions are addressed accordingly. Wishing you a wonderful week ahead.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement