Skip to main content
May 23, 2024
Question

Cancelled Visa transactions not available for syncing with bank

  • May 23, 2024
  • 1 reply
  • 0 views

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.

1 reply

May 23, 2024

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

Travis111Author
May 23, 2024

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?

May 23, 2024

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?