The India GST Report can be used by Properties in India for filing monthly business tax.
Overview
The India GST Report includes the following two sections:
Without GST - Consumer Sales
All Tax Invoices generated with the applicable Tax Grouping where the entity selected as the 'Bill To' does not include an ABN.
GST - B2B Sales
All Tax Invoices generated with the applicable Tax Grouping where the entity selected as the 'Bill To' includes an ABN.
Use Cases
- Monthly GST filing - Properties in India run the report for the month's invoice date range to prepare their business tax lodgement.
- Consumer vs B2B reconciliation - Use the two report sections to confirm invoices are correctly split between consumer sales and B2B sales before filing.
- Handover to an accountant - Tick Direct Export to .csv to produce a file the property's accountant or tax software can work with directly.
How to Access
In the side menu of RMS, go to Reports > Accounting > India GST.
Guide
- Select the Invoice Date Range.
- Select a Sort By option.
- Select the checkbox 'Direct Export to .csv' (Optional).
- Select Build.
The India GST Report will include all Tax Invoices where the included Taxes were assigned a Tax Grouping with 'GST' in the description.
Report Options
| Report Option | Type | Default | Description |
|---|---|---|---|
| Invoice Date Range | Date range | Yesterday | Date range for Tax Invoices to include in the report. |
| Sort By | Dropdown | Invoice No | Sorts the report output. |
| Direct Export to .csv | Checkbox | Unticked | When ticked, exports the report directly to a CSV file instead of the built-in viewer. Optional. |
| Property | Multi-select | Current property | Limits the report to the selected properties. Shown on multi-property (Enterprise) databases only. Optional. |
Report Columns
The CSV export of the report includes the following columns.
| Column | Description | Source / Calculation |
|---|---|---|
| Property | The Property associated to the Account the Tax Invoice was created on. | Property setup |
| Invoice Number | Unique identifying number associated with the Tax Invoice. | Invoice record |
| Reservation Number | The Reservation Number associated to the Account the Tax Invoice was created on. |
Reservation record |
| Area | The Area selected on the Reservation the Tax Invoice was created on. |
Reservation record |
| Guest Name | The Primary Guest Name on the Reservation the Tax Invoice was created on. |
Guest Profile |
| Arrive | The Arrival Date selected on the Reservation the Tax Invoice was created on. |
Reservation record |
|
Depart |
The Departure Date selected on the Reservation the Tax Invoice was created on. |
Reservation record |
| User | Name of the User that created the Tax Invoice . | User account |
| Company | The Company selected on the Reservation the Tax Invoice was created on. | Company record |
| Travel Agent | The Travel Agent selected on the Reservation the Tax Invoice was created on. | Travel Agent record |
| GST Number | Guest Profile / Company / Travel Agent | |
| Invoice Date | The Accounting Date of Tax Invoice creation. | Invoice record |
| Invoice Amount | The total amount of the Tax Invoice . | Invoice record |
| GL Code | The General Ledger Account Code of the charges on the Tax Invoice. | GL Account Code setup |
| SAC Code | Sundry / GL setup | |
| Discount | Discount applied to charges on the Tax Invoice. | Transaction record |
| Travel Agent Commission | Travel Agent Commission on the Reservation the Tax Invoice was created on. | Travel Agent setup |
| Taxable Amount |
|
Calculated |
| Non Taxable Amount |
|
Calculated |
| Settlement | Receipt Type selected for payment on the Tax Invoice. | Transaction record |
| Receipt Amount | Total amount Receipted on the Tax Invoice. | Transaction record |
| Accounts Receivable Transfer Name | Accounts Receivable Account the Tax Invoice has been allocated to. | AR account record |
| Refunds |
|
Transaction record |
The on-screen report groups invoices into the two sections, with summary columns including Res No, Account No, Invoice Date, Invoice No, IRN No, Total Invoice Amount, Taxable GST, Tax Rate, Tax Amount, and Settlement Mode.
Data Sources & Calculations
The following concepts govern the data shown in this report.
Tax Grouping
Inclusion on this report, and the values in the GST-related columns (Taxable Amount, Non Taxable Amount, Taxable GST, Tax Rate, Tax Amount), are driven by Tax Grouping: only Tax Invoices whose included Taxes are assigned a Tax Grouping with GST in the description appear on the report.
Consumer Sales vs B2B Sales sections
The entity selected as the Bill To on the Tax Invoice determines its section: invoices billed to an entity without a registered business number appear under Without GST - Consumer Sales, and invoices billed to an entity with one appear under GST - B2B Sales. The same columns are reported in both sections.
Related Reports
- Invoice List Report - All Tax Invoices created in a period, with revenue and receipt breakdown options.
- GST Assignment Report - How taxes are assigned across charges at the property.
- Invoice Audit Report / Credit Note - The audit history of changes made to individual invoices, including credit notes.
Comments
0 comments
Please sign in to leave a comment.