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

Cancelled Visa transactions not available for syncing with bank

Hi,

 

I began to launch a landscaping business in the fall of 2023 in preparation to start in the spring of 2024. I opened a business account along with a business Visa. After using the Visa for some start-up costs, it remained inactive for many months during the winter with a very low balance owing on it. As part of the bank's anti-fraud policy, they cancelled all cards associated with the account without notice dues to inactivity! Yes, they do that!

 

Since the Visa was at a low balance owing, they cancelled it with no problem sometime early in 2024. I don't know when exactly because I was still able to log-in online and view the accounts even though the cards had been cancelled. In the meantime, because I didn't have a lot of transactions to record and I wanted to save on a monthly Quickbooks subscription cost for six months with virtually zero activity, I simply kept all of my receipts as a record until I got a Quickbooks online subscription just before starting business in the spring.

 

I didn't find out my accounts were cancelled until March of 2024 when I went to deposit a cheque from a client at the bank machine and I couldn't do so. I ended up having to re-opened the accounts and they issued new cards.

 

Now here is where the real issue begins. Because the old accounts were deactivated, I can't sync them with Quickbooks. The current card only goes back to the beginning of March but I want to keep track of my transactions back to Jan 1, 2024. This is causing some major issues because now I've categorized all of the transactions I can sync with the bank but the final balances don't coincide. I can login to online banking and see the monthly transactions still so if there is a way to manually enter a starting balance (or edit it) from January 1, 2024 and then manually enter the missing transactions, that would be very helpful but I can't seem to figure it out even after combing through this forum or searching the Youtube videos. I've managed to figure out how to enter the transactions for reconciliation purposes but the transactions still don't show up prior to the beginning of March when the new Visa was issued and as a result the bank balance does not line up with the Quickbooks balance even though it's got a tidy little green checkmark on it.

 

Any help would be appreciated. Thank you.

8 Comments 8
4Gal
Level 11

Cancelled Visa transactions not available for syncing with bank

What file format does your back provide to download your historical transactions? e.g *.csv, *.pdf

Travis111
Level 1

Cancelled Visa transactions not available for syncing with bank

The Visa account is linked to Quickbooks and I've tried simply hitting the "update" button but that didn't work so I tried doing it manually. The bank allows me to download a variety of file formats. I've tried the .qbo format and the .csv format and both only go back to the beginning of March. I have opened the .csv format in excel to confirm and yes, it only shows transactions back to the beginning of March. And yes, I have selected "all transactions" and not just "transactions since last download." The strange part is that when I view back to the beginning of January online, it shows all the transactions the .csv file is missing. I'm sure it has something to do with the cancellation of the old Visa because the old Visa has a different account number even though, for banking purposes, all the transactions are now lists under the new card seamlessly in online banking view.

 

I've contacted the person I dealt with to get my accounts reinstated to see if the can help. If they can't, I was thinking of manually editing the .csv file to show the missing transactions but I don't want to do something wrong and make even more of a mess. I'm also not sure what would happen if I hit the auto "update" button in the future. Would it revert back to only showing up to the beginning of March or would it retain the old manually entered ones?

JamesM4
QuickBooks Team

Cancelled Visa transactions not available for syncing with bank

Hello Travis111. Are you looking to enter the missing transactions manually? If so, are you able to download the transactions from your bank and enter them in QuickBooks using the steps provided in this article here?

Travis111
Level 1

Cancelled Visa transactions not available for syncing with bank

Yes, as I explained already, when I download the .csv file from the bank to then manually upload into Quickbooks, the .csv file transactions only go back to the beginning of March, yet when I view the statements, they go back to the fall of 2023. Is this a credit card thing maybe where they only go back so far?

JamesM4
QuickBooks Team

Cancelled Visa transactions not available for syncing with bank

Hello Travis. I see what you're saying. QuickBooks is designed to upload only 90 days of banking data when you initially connect the bank. Any transactions that go beyond the 90 days would have to be uploaded manually. Are you getting an error on your Banking screen in QuickBooks? 

Travis111
Level 1

Cancelled Visa transactions not available for syncing with bank

Yes, I have since found out that credit cards only go back so far but there is no way to upload manually since the file taken from the bank to upload manually only goes back as far as the automatic upload will go. I can go back and enter older transactions individually by hand using the method in the link below but the Quickbooks total will never match the Bank transactions total by doing this since the bank transactions total only uses transactions dating back so far. You cannot alter bank transactions to force the match. There may be a way to sort of fudge it by altering the opening balance to be the same as the first bank transaction but that wouldn't be completely accurate and I would have to put any transactions before that opening date under a single uncategorized amount.

 

I still think there may be a way to edit the .csv file to manually add prior transactions simply by following the same formatting. It's quite a simple format actually and a person is even given instructions on how to edit it if the formatting isn't correct to begin with but I'm not up to giving it a shot in case I mess it up further.

 

https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-registers/reconcile-transactions...

Henock K
QuickBooks Team

Cancelled Visa transactions not available for syncing with bank

Hi Travis,

 

As mentioned by my colleague above, you'd need to upload them manually by using the CSV file. I encourage you to review these articles that might help you.

 

-Format CSV files in Excel to get bank transactions into QuickBooks

-Manually upload transactions into QuickBooks Online

-Reconcile transactions that are older than your opening balance in QuickBooks Online

-Enter and manage opening balance for an account in QuickBooks Online

 

Let me know if you have questions, I'll be happy to help.

 

 

 

Travis111
Level 1

Cancelled Visa transactions not available for syncing with bank

Hi,

 

As I mentioned above, the .csv file does not date back far enough so it is of no use. This does not solve the problem.

Need to get in touch?

Contact us