Armanino Blog
Article

Reconciling the Corporate Credit Cards

December 14, 2008

I recently had a client call me wondering if there was some easier way to reconcile his corporate credit cards. Sales people had one credit card (Visa) and the executives used another (American Express.) A total of 16 people using two cards - reconciling monthly was giving him a headache. I shared with him, what I consider, the easiest solution to this monthly migraine:

  • Set up a Checkbook for every credit card along with a corresponding GL control account
  • Setup a GL Credit Card Clearing Account
  • Enter all purchases through Bank Transaction Entry (Transactions > Financial>Bank Transactions as a decrease adjustment to post the expense
  • Enter the Credit Card Statement through Account Payable (Transactions > Purchasing > Transaction Entry) and post the statement payment to the Credit Card clearing Account.
  • Pay the credit card statement as normal, hitting your cash account and AP.
  • Enter the payment as a decrease adjustment in the Credit Card Checkbook hitting the credit card clearing account. This will post the payment to the bank account allowing for reconciliation and zero out the clearing account.
Reconciling Corporate Credit Card through Bank Managment>

Reconciling through Bank Managment has made his monthly credit card reconciliations much quicker and is a whole lost easier then using an excel spreadsheet.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Resources
Related News & Insights
Costco Travel Webinar
Webinar
One of the world’s top retailers reveals their cloud upgrade process.

May 19, 2022 | 11:00 AM - 11:30 AM PT
Overview of Sage Intacct R2 Release Webinar
Webinar
Learn the newest features and enhancements in Sage Intacct from the 2022 Release 2.

May 18, 2022 | 01:00 PM - 02:00 PM PT
Foundation Cuts Manual Data Entry, Empowers Staff With Robotic Process Automation
Case Study
RPA tech enables lasting growth, boosts savings and frees up staff to redirect their time to meaningful strategies.

May 18, 2022