(Created page with "==Introduction== Sometime we wanted to make sure all the data is corrected posted/Records so we need some ''Extra'' report(s) to check before we can submit to * Top Management...") |
|||
| (9 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Introduction== | ==Introduction== | ||
Sometime we wanted to make sure all the data is corrected posted/Records so we need some ''Extra'' report(s) to check before we can submit to | Sometime we wanted to make sure all the data is corrected posted/Records so we need some ''Extra'' report(s) to check before we can submit/report to | ||
* Top Management | * Top Management | ||
* Auditor | * Auditor | ||
| Line 6: | Line 6: | ||
==Reports== | ==Reports== | ||
{| class="wikitable" | {| class="wikitable" style="margin: 1em auto 1em auto;" | ||
|- | |- | ||
! Report Name !! Report Type !! Description | ! Report Name !! Report Type !! Description | ||
|- | |||
| GST-Ledger-GST-Output Tax Prepaid || GL Ledger || To list out which Transactions still Outstanding for GST-Output Tax Prepaid | |||
|- | |- | ||
| GST-Ledger-Vs-GST-03_5b || GL Ledger || Check between GST PAYABLE account & the GST-03 5b Transactions | | GST-Ledger-Vs-GST-03_5b || GL Ledger || Check between GST PAYABLE account & the GST-03 5b Transactions | ||
|- | |- | ||
| GST-Ledger-Vs-GST-03_6b || GL Ledger || Check between GST CLAIMABLE account & the GST-03 6b Transactions | | GST-Ledger-Vs-GST-03_6b || GL Ledger || Check between GST CLAIMABLE account & the GST-03 6b Transactions | ||
|- | |- | ||
| Sales Local - Invoice Listing (GST 1) - SLvsAR || Sales Invoice Listing || Check between Sales Invoice & Customer Invoice Transactions | | Sales Local - Invoice Listing (GST 1) - SLvsAR || Sales Invoice Listing || Check between Sales Invoice & Customer Invoice Transactions | ||
| Line 31: | Line 31: | ||
|- | |- | ||
| Purchase Local - Purchase Return Listing (GST 1) - PHvsAP || Purchase Return Listing || Check between Purchase Return & Supplier Credit Note Transactions | | Purchase Local - Purchase Return Listing (GST 1) - PHvsAP || Purchase Return Listing || Check between Purchase Return & Supplier Credit Note Transactions | ||
|- | |||
| GL Journal of Transaction - Inbalance || GL Journal of Transaction || Make sure Total Local DR & Total Local CR for each transaction is balance | |||
|- | |||
| Sales Customer Price History (GST 1) - Review || Sales Price History || Make sure Local Amount & Local Tax amount is correctly calculated | |||
|- | |||
| Purchase Supplier Price History (GST 1) - Review || Purchase Price History || Make sure Local Amount & Local Tax amount is correctly calculated | |||
|- | |||
| Customer - GST Review || Customer Invoice Listing || Make sure Local Amount & Local Tax amount is correctly calculated for ALL Customer Invoice, Debit Note & Credit Note | |||
|- | |||
| Suppplier - GST Review || Supplier Invoice Listing || Make sure Local Amount & Local Tax amount is correctly calculated for ALL Supplier Invoice, Debit Note & Credit Note | |||
|- | |||
| GL Cash Book Listing - GST Review || GL Cash Book Listing || Make sure Local Amount & Local Tax amount is correctly calculated for ALL Official Receipt & Payment Voucher | |||
|- | |- | ||
| Cust Local - Payment Listing (GST 1) - Opening Bad Debts || Customer Payment Listing || Make sure Past Payment with GST is properly recorded | | Cust Local - Payment Listing (GST 1) - Opening Bad Debts || Customer Payment Listing || Make sure Past Payment with GST is properly recorded | ||
| Line 40: | Line 52: | ||
| Supp Local - Credit Note Listing (GST 1) - Opening Bad Debts || Supplier Credit Note Listing || Make sure Past Credit Note with GST is properly recorded | | Supp Local - Credit Note Listing (GST 1) - Opening Bad Debts || Supplier Credit Note Listing || Make sure Past Credit Note with GST is properly recorded | ||
|} | |} | ||
* More Coming Soon.... | |||
==See also== | |||
* Others [[Customisation]] | |||
Latest revision as of 03:26, 20 March 2018
Introduction
Sometime we wanted to make sure all the data is corrected posted/Records so we need some Extra report(s) to check before we can submit/report to
- Top Management
- Auditor
- Kastam
Reports
| Report Name | Report Type | Description |
|---|---|---|
| GST-Ledger-GST-Output Tax Prepaid | GL Ledger | To list out which Transactions still Outstanding for GST-Output Tax Prepaid |
| GST-Ledger-Vs-GST-03_5b | GL Ledger | Check between GST PAYABLE account & the GST-03 5b Transactions |
| GST-Ledger-Vs-GST-03_6b | GL Ledger | Check between GST CLAIMABLE account & the GST-03 6b Transactions |
| Sales Local - Invoice Listing (GST 1) - SLvsAR | Sales Invoice Listing | Check between Sales Invoice & Customer Invoice Transactions |
| Sales Local - Cash Sales Listing (GST 1) - SLvsAR | Sales Cash Sales Listing | Check between Sales Cash Sales & Customer Invoice Transactions |
| Sales Local - Debit Note Listing (GST 1) - SLvsAR | Sales Debit Note Listing | Check between Sales Debit Note & Customer Debit Note Transactions |
| Sales Local - Credit Note Listing (GST 1) - SLvsAR | Sales Credit Note Listing | Check between Sales Credit Note & Customer Credit Note Transactions |
| Purchase Local - Purchase Invoice Listing (GST 1) - PHvsAP | Purchase Invoice Listing | Check between Purchase Invoice & Supplier Invoice Transactions |
| Purchase Local - Cash Purchase Listing (GST 1) - PHvsAP | Purchase Cash Purchase Listing | Check between Purchase Cash Purchase & Supplier Invoice Transactions |
| Purchase Local - Debit Note Listing (GST 1) - PHvsAP | Purchase Debit Note Listing | Check between Purchase Debit Note & Supplier Debit Note Transactions |
| Purchase Local - Purchase Return Listing (GST 1) - PHvsAP | Purchase Return Listing | Check between Purchase Return & Supplier Credit Note Transactions |
| GL Journal of Transaction - Inbalance | GL Journal of Transaction | Make sure Total Local DR & Total Local CR for each transaction is balance |
| Sales Customer Price History (GST 1) - Review | Sales Price History | Make sure Local Amount & Local Tax amount is correctly calculated |
| Purchase Supplier Price History (GST 1) - Review | Purchase Price History | Make sure Local Amount & Local Tax amount is correctly calculated |
| Customer - GST Review | Customer Invoice Listing | Make sure Local Amount & Local Tax amount is correctly calculated for ALL Customer Invoice, Debit Note & Credit Note |
| Suppplier - GST Review | Supplier Invoice Listing | Make sure Local Amount & Local Tax amount is correctly calculated for ALL Supplier Invoice, Debit Note & Credit Note |
| GL Cash Book Listing - GST Review | GL Cash Book Listing | Make sure Local Amount & Local Tax amount is correctly calculated for ALL Official Receipt & Payment Voucher |
| Cust Local - Payment Listing (GST 1) - Opening Bad Debts | Customer Payment Listing | Make sure Past Payment with GST is properly recorded |
| Cust Local - Credit Note Listing (GST 1) - Opening Bad Debts | Customer Credit Note Listing | Make sure Past Credit Note with GST is properly recorded |
| Supp Local - Payment Listing (GST 1) - Opening Bad Debts | Supplier Payment Listing | Make sure Past Payment with GST is properly recorded |
| Supp Local - Credit Note Listing (GST 1) - Opening Bad Debts | Supplier Credit Note Listing | Make sure Past Credit Note with GST is properly recorded |
- More Coming Soon....
See also
- Others Customisation