|TBCB Cash Basis for Sage 100 transforms the standard Time and Billing programs into a cash basis system. Revenues are recognized only when cash is received. Sales Tax can continue to be handled on an accrual basis, even if Time and Billing Cash Basis is activated. A report has been added that prints Open Invoices by General Ledger revenue account.|
If a company is operating on a Cash Basis, General Ledger postings are not made when the Billing Register is updated. Rather, the detail is saved and posted at the time that cash is received for the Billing. The Cash Basis modifications work for both Open Item Clients and Balance Forward.If the company is setup to be on a Cash Basis, sales taxes can still continue to be on an accrual basis. This is mandatory in some states.There is a utility feature built into the Time and Billing Sort Rebuild program that can be used to initialize the necessary cash basis files from existing Open Invoice information previously expensed on an accrual basis. This rebuild also “forces” General Ledger distribution back into balance for any invoices which have fallen out of balance, for any reason.
Time and Billing Cash Basis does not change any of the standard Sage 100 ERP reports, however, there is a new Open Invoice General Ledger Account Detail Report that summarizes the General Ledger distribution activity for each open invoice on the system. This report will prove useful for companies calculating end of year tax adjustments, and whose books are kept on a cash basis but whose taxes are accrual-based.
The invoice balance is compared to the sum total of the distribution detail and an **OUT OF BALANCE** flag is printed for any invoice whose detail does not match the invoice balance. The user may put the system back into balance by rebuilding Application Sort Files for Time and Billing. However, if the Distribution is chronically out of balance there may be a much more important system problem that should be looked into. Checking is only done when all General Ledger accounts are selected.
The T/B Cash Basis modifications for Sage MAS 90 and Sage MAS 200 allows the T/B user to: