Lease GST Report

This report lists tax information for leases for a selected date range. The report is based on the assumption of one lease per account and includes a detail line for each account with an applicable lease invoice, then includes a total line for all accounts listed on the report.

The detail line for each account includes the date, invoice number, A/R account, A/R account type, company name, lease number, lease name, lease start date, lease period start date, and then transaction amounts for standard rate, zero rate, exempt, not applicable, GST, and the invoice total. The total line includes the total amounts for standard rate, zero rate, exempt, not applicable, GST, and invoice total.

You can filter the report by account type. You can create the report under the date context of the invoice date or lease period start date. You can optionally show rental, maintenance, service, and incidental information. You can optionally show rental credit notice, hire credit notice, maintenance credit notice, and service credit notice. You can optionally include non-lease invoices. You can sort the report by invoice, account, or A/R account.

The following are some important points to be noted:

• When the report is created under the date context of lease period start date, the filtering and dates are the invoice period start date. For incidentals and non-lease the invoice date is always used.
• A/R invoices can be for lease invoices or for invoices of guest stays that are on leases.
• Incidental invoices are not directly related to a lease period. Guest stays can only produce an incidental invoice.
• Generally, leases are invoiced in advance of the actual billing. The system must look at the revenue recognition charges to determine taxes. These revenue recognition charges are not posted yet. The system must use trial posting for the future dates.
• When the rental amount and fees are billed together, the rental amount may not be under one charge category. The system must use the trial posting table to get the revenue details for future dates. Since the revenue recognition charges have the tax groups, the revenue recognition charges are used to determine the amounts.