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
  • 4 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. 

P
Pete_Mc
Level 5
January 22, 2022

In addition to what @Rose-A said...  Be sure to go back to your monthly bank statements and Reconcile each month.  It will REALLY help keep things in order and make sure that all the bank records are in order. 

(My guess is your Tax Accountant is also going to want to know if the accounts are Reconciled.)

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