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?