Bennington
Occasional Member - Level 3

Hi,

We use a slightly different approach for our CBCP cards involving a transitory account in our G/L.

When we receive the monthly statement information from our bank (download in CSV), we create a posting that credits the full statement amount to the Bank Vendor, then creates indiviudal debit lines for each card transaction into a transitory account. In each of the debit lines we record the individual transaction ID supplied by the bank.

然后,当我们处理clai费用ms from Concur, and CBCP card transactions debit the relevant Expense G/L account (based on expense type) and create credit postings in the transitory acccount, recording the transaction ID into the same field. Then it is simple to run an automatic clearing process over the transitory account to group transactions that share the same transaction ID and have a balance of 0, and mark them as cleared.

This method helps us keep our "real" G/L clean, with only approved, cleared expenses being posted, whilst in the mean time allowing us to track the un-reconciled expenses in the transitory account. At the end of each month, our finance team can look at the total in the transitory account and enter a suitable accrual which is then reveresed at the start of the following month.

I hope this helps, happy to provide any additional info if requested.

Dave