cancel
Showing results for 
Search instead for 
Did you mean: 
finance32
Level 1

Best way to deal with missing data from a direct feed that's permanently stopped

Hi there. All my accounts are direct fed into QB Online.

 

Today, I made the silly mistake of cancelling a credit card before sync the expenditure data to QB via the direct feed. It now has about 5 months of missing data and the bank won't reopen the feed for me or "uncancel" my card.

 

I can still manually access the statements and expenditure data via the bank's website for a few months.

 

What's the best way to get the data mannually into QB?

 

Can I somehow append the data to the QB credit card account after the feed has stopped?

 

Should I just start a separate QB account (cash or otherwise) and copy and paste the data there? If so, what's the best way to do that?

 

Thank you.

2 Comments 2
GlinetteC
Moderator

Best way to deal with missing data from a direct feed that's permanently stopped

I assure you I have all the information to handle and bring those missing transactions to QuickBooks Online, finance32.

 

You can import your bank statement by downloading a CSV file format and uploading it manually to the system. 

 

  1. Log in to your bank or credit card's website.
  2. Follow the instructions provided by your bank to download CSV files containing your transaction history to your computer. Every financial institution has different steps.
  3. Make sure the date range for the download is at least one day before your oldest transaction.
  4. Download the transactions and save the file in a location that is easily accessible, such as your computer's desktop.

 

Then, upload the transactions to QBO. You can follow the steps below.

 

  1. Navigate to the Transactions tab and click on Bank transactions
  2. Locate and click on the blue tile representing the account where you want to upload the transactions.
  3. Click the Link account ▼ dropdown and then Upload from file.
  4. Choose either the Drag and drop option or select files to locate and select the file you downloaded from your bank. Then, click on Continue.
  5. In the QuickBooks account ▼ dropdown, select the account you want to upload the transactions into. Then select Continue.
  6. Follow the onscreen instructions to match the columns from the file with the appropriate fields in QuickBooks. Then, click on Continue.
  7. Select the transactions you want to import, and click on Continue.
  8. Confirm by selecting Yes, then click on Done to complete the process.

 

After downloading your banking data, you can categorise them for proper accounting and reconcile the account for accurate financial records.

 

Let me know if you have further questions about handling missing transactions and other related issues. I'll be here to assist.

4Gal
Level 10

Best way to deal with missing data from a direct feed that's permanently stopped

@finance32 

You can use one of the converter tools (e.g csv2qbo @ $60 one time license) as a workaround.

https://www.moneythumb.com/?ref=110