Follow the steps below to reconcile the figures in Striven to what is shown in your External GL package like MYOB or XERO.

A spreadsheet has been created that helps in balancing the two systems. It can be found here.

Open

Debtors

You can match the “Trade Debtors” or “Accounts Receivable” value to the Debtor Trial Balance report in Striven.

But when trying to reconcile you also need to take into account any Customer Order Deposits made in that period. These deposits are a “Liability” to your business, but those monies have been added to your “Trade Debtors” / “Accounts Receivable” balance when the Deposit was created, so we need to deduct these values from the “Trade Debtors” account.

The Trade Debtors is equal to the Monthly “Debtor Movement” MINUS “Customer Order Liability”

Debtor Movement

To get this information, run the Debtor Trial Balance report with Summary set to Yes.

The “movement” is the balance from Last Month and the balance from This month.

Open

Open

Customer Order Liabilities

Customer Order Deposit GL Posting

When a Deposit is made on a Customer Order, it would do the following.

Total Sale: $1000

Deposit Paid: $100

Tender: CASH

No postings were made to SALES or STOCK as yet, as it was a Customer Order. It would only get posted to those when the Customer Order was TAKEN.