How to reconcile Balance Sheet Account?
Example:
How do you know which AP already paid
or Which AR already received
Here is the step:
Case: Account Payable Account is 337110, we want to know what transaction have not been paid!
- In SunSystems you have 10 Analysis, Please open GDCoA Setup
- Open 337110 then amend and make DTLS is Mandatory
- Go to Analysis Code Setup
- Analysis Dimension is : DTLS Analysis Code : R Name : Reconcile
- Generate Statement of Account : 337110
- Check for Transaction that already paid (Check Debit and Credit)
- Go to Account Allocation
- Mark the Transaction R in DTLS Analysis
- Create a Report in Excel
- Generate 337110 with DTLS without R
- You will get Transaction without R, it means have not paid yet
There is other way to Reconcile that already prepared by SunSystems, the same way but not in DTLS but in Allocation Marker.
