Forum Discussion

Swampy-66's avatar
Swampy-66
Experienced Cover User
2 years ago

Credit Card

Hi I have a bank feed from my amex account which has two cards on the one account. One card is for personal use and the other for business. Reconciling this via a bank feed is problematic as the opening and closing balances are combined ie business and personal. In the past i have look at all the business transaction and used that as the closing balance, but the payment made is never recorded as the next statemnet as the balance of the business card (its listed as combined payment) on the next statement so marring up the transactions it a challenege and adjusting figure to reconcile the transtraction is starting to get messy as the previous person wasnt reconcile the transaction correctly and there are also several outstanding charges and payments that are not reconciled prior to the last reconciled date  

 

Other than separtaing the cards on 2 separate accounts which i prefer not to do as it will come with additinal card feed. Is there a simple solution? 

 

an secondly whats the best way to bring the reconciliation procile back to a valid state with older transactions?

 

 

 

 

  • Hi Swampy-66 

     

    Thanks for your post. If you are wanting to reconcile the account to match the statement you will need to enter the personal purchases. You'd need to check with your accountant about creating an applicable account. To save data entry time, you could record one bulk transaction for the period for all personal transactions.

     

    Your other option would be to manually separate the business expenses and payments. To reconcile older transactions you will need to undo the reconciliations and re-reconcile to include those transactions.

     

    Please let me know if you need further help.

     

    If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.