Striven HELP
General Ledger Reconciliation
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.
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
Previous months Debtor Trial Balance minus Current Month Debtor Trial Balance
Customer Order Liability
Customer Order Deposits
plus Customer Order Payments
minus Customer Order Deposits Used
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.
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.
Account | DR | CR |
---|---|---|
Trade Debtors |
| 100 |
CASH Tender | 100 |
|