Credit Card Balance Discrepancy
- May 15, 2024
- 1 reply
- 0 views
Hello,
I hope someone can help with a problem I am seeing whereby credit card 'Bank Balances' are displaying incorrectly in QBO in certain circumstances. I ran a simple test to help illustrate the problem, as described below (please refer to images in the attached file).
Image 1 shows the correct credit card balance as displayed in the AMEX online portal. It is a negative (credit) balance meaning the card issuer owes the cardholder.
Image 2 shows the same credit card account twice on the Bank Transactions screen in QBO. The first instance 'Credit Card (Linked)' was connected to the AMEX account using the Link account feature. The second instance 'Credit Card (Unlinked)' was created using the Upload from file feature. The file uploaded was a .qbo file. After linking/importing, all transactions were categorized and the both accounts were reconciled.
Image 3 shows the 2 credit card accounts in the Chart of Accounts.
Questions:
- Why is the bank balance of the 'Credit Card (Unlinked)' account on the Bank Transactions screen different than the actual balance as shown in the AMEX portal (e.g $1.40 vs -$1.40)?
- Why are the bank balances of the 2 accounts as shown on the Bank Transactions screen different (e.g -$1.40 vs $1.40)?
- Why are the bank balances for both accounts as shown in the Chart of Accounts different than the actual balance as shown in the AMEX portal (e.g $1.40 vs -$1.40)?
- Why is the bank balance of the 'Credit Card (Linked)' account in the Chart of Accounts different than the bank balance shown on the Bank Transactions screen (e.g $1.40 vs -$1.40)?
Thanks in advance for any ideas on this.
