Help with credit card payables

Hello,

I recently took over the accounting for a company and am having trouble figuring out the credit card payable accounts. The balances are not clearing after being paid and I think I know why. The credit card bills were done in 2 different ways: The bill would be done up in purchases to the credit card company with all of the accounts referenced according to the purchases on the credit card and paid from the bank account.  

However, any purchases done using credit cards that had invoices (larger purchases) were also done up for the actual companies and paid using the credit card payment option. The problem I'm having now is that the credit card payables accounts in banking are showing large balances that haven't cleared. I'm guessing because those purchases done that were paid by credit card were never cleared out by doing the pay credit card bills option in payables.

I'm wondering if I can do a general journal entry to clear these amounts out rather than fixing each individual credit card invoice.

Thanks for any help!

Andrew

  • 0

    Yes, general ledger entries are treated the same as A/P module entries.  The reconciliation amounts are the G/L amounts, so it doesn't matter whether the cards are posted through A/P or through the G/L.  

    If you set up the credit card G/L account for reconciliation, it will reconcile like any bank account.

    So yes, if you've sorted out what should, and should not be there, you can combine the corrections into one summary entry.

    ----------------------------------------------------------------------------------------------------

    For Credit Cards, I've found that only, always, exclusively entering everything through the Purchase / A/P module in SA works out better.   There's almost always an invoice, most slips have at least a unique 'transaction I.D'.  

    For transactions that just plain do not have an invoice number, I use a consistent date format (i.e. 2015-11-21) as the invoice number, to help avoid duplicates.

    I don't know when or why (perhaps from course work that's intentionally difficult), it seems that  some book-keepers have gotten the idea that it's best to use the G/L first, and the other Sage 50 screens are only a last resort, or for noobs that don't grok the debits and credits.  

    I'm of the opposite opinion.