At its most basic level, reconciliation accounting involves comparing two sets of records to ensure that they match and that the balance shown in each set is correct. However, given the complexity of most modern ecommerce companies—which may generate separate sets of records from their banks, payment processors, return solution, and other sources—reconciliation in accounting can prove difficult without the right processes or systems in place.
To better understand the importance of reconciliation, as well as the unique challenges faced by ecommerce retailers, let’s start with some helpful background information.
The easiest way to understand reconciliation is to think of your household budget. Imagine that, throughout each month, you track your income and expenses in a spreadsheet. Then, at the end of the month, you check the running total in your spreadsheet against the total in your bank account.
If the two sets of records (in this case, your spreadsheet and bank statements) match, your account is considered reconciled. If not, you’ll need to do some digging to understand where the discrepancy occurred. Perhaps you forgot to record the amount left as a tip on a restaurant transaction, or maybe you were double-billed for something unexpectedly. Once you find and resolve the issue, you’re back to a reconciled state.
On a corporate scale, reconciliation serves a similar purpose. Companies that follow the generally accepted accounting principles (GAAP) typically reconcile budget numbers using double-entry bookkeeping, in which transactions are entered into the general ledger twice, in both credit and debit accounts.
When done correctly, reconciliation accounting serves several purposes.
Although key accounts may vary from company to company, some of the most common accounts to be reconciled include:
In addition to general accounts reconciliation, companies may also perform more specific types of reconciliation, including:
In some cases, account reconciliation may involve intermediary steps. In the case of credit card reconciliation, for example, companies may need to first match their credit card statements to reporting from their POS in order to match aggregate numbers with their bank statements.
There’s also some level of overlap between the types of reconciliation described above. As an example, invoice reconciliation may encompass customer reconciliation and vendor reconciliation. Individual companies and their accounting teams may use different terminology to describe the specific types of reconciliation they execute.
Also complicating the reconciliation process for ecommerce merchants is the issue of returns.
Recording an ecommerce transaction under GAAP is more complicated than simply debiting the value of the inventory and recording the total purchase price as a credit on the general ledger. Generally, companies need to:
When returns occur, these journal entries need to be reversed. If the amount of the return changes from the initial purchase—for example, because you charge a return fee or need to issue a refund for a defective item—additional entries may need to be created to ensure the accounts can be properly reconciled.
Account reconciliation is a critical piece of running a successful business. We recommend getting in touch with an accountant to make sure your business maintains proper account information.
If you liked this article, you might also like, “How to Calculate Inventory Turnover,” or "The Customer Returns Process and RMA Process Defined."