Reconcile your General Ledger

To reconcile your General Ledger, you need to verify that the ending balance is equal to the starting balance plus your net transactions (the sum of your revenue, payments, and deposits) from the period you are reconciling.

Note: You cannot run a trial balance report in Commander because debits and credits are not tracked.

Step 1: Record your starting and ending balance

  1. Go to Main menu > Finance > Accounting ledger.
  2. Apply the following filters before you run the report:
    • Under Type, select General.
    • Under Date, select the first day of the period you want to reconcile. For example, if you reconcile your accounts on a monthly basis, select the first day of the last month (e.g., 12/1/2018) at 12:00 AM.
  3. Click OK > View report.
  4. Make note of the total amount listed under the General ledger column—this is your starting balance (you’ll need it again in Step 3).
    • Your General ledger balance is your Guest ledger balance plus your Deposit ledger balance.
  5. Run the report again with the following filters:
    • Under Type, select General.
    • Under Date, select the last day of the period you want to reconcile. For example, if you reconcile your accounts on a monthly basis, select the first day of the current month (e.g., 1/1/2019) at 12:00 AM.
  6. Click OK > View report.
  7. Make note of the total amount listed under the General ledger column—this is your ending balance (you’ll need it again in Step 3).

Step 2: Calculate your net transactions

Make note of your net transactions (revenue, payments, and deposits) from the period, so you can match your starting balance to your ending balance in Step 3.

  1. Go to Main menu > Finance > Accounting report.
  2. Apply the following filters before you run the report:
    • Under Type, select Consumed.
    • Under Start, select the first day of the period you want to reconcile (the same date and time selected in Step 1).
    • Under End, select the last day of the period you want to reconcile (the same date and time selected in Step 1).
  3. Click OK > Export.
  4. Download the export file (you'll receive a notification when it's ready to be downloaded).
  5. Open the file on your computer.
  6. Go to the Items tab.
  7. Calculate the total of the Amount column, and make note of the sum—this is the net total of your transactions (you'll need it again in Step 3).
    • This total includes your revenue, payments, and deposits.

Step 3: Verify your ending balance

If your ending balance is correct, it will match the sum of your starting balance and net transactions.

  1. Add your net transactions (found in Step 2) to your starting balance (found in Step 1).
    • For example, if the net total of your transactions is €4,000 and your starting balance is €45,000, your final sum will be €49,000.
  2. Compare the sum to your ending balance. If they are the same, your General Ledger has been reconciled.