U04 End of Period

U0449 Use Tax Disbursal

For more information about End of Period,
refer to U04 End of Period Overview.

This module reports the use tax to disburse to various taxing entities (state, county, and city). It also clears the reported payable amount from the Use Tax Payable General Ledger for each office.

If the Transit Tax enhancement, part of the 1993 JULE Fund, has been purchased, then transit taxes (or other fourth level taxes in addition to state, county and city) will be split out on a separate line on the Use Tax Disbursal reports. The county or city rates and tax amounts will appear net of any fourth level tax rates and tax amounts.

Vertex O users: U0449 Use Tax Disbursal will not process Vertex O records. Vertex O records will be disbursed through U0307 Vertex O Disbursal.

Seven standard reports are produced by this module:

• U0449A Use Tax Disbursal Location Listing (p##_lpu0449a.rpt) reports detailed use tax payable information for each asset, in city tax rate, city, county tax rate, county, state tax rate and state order. This report may be used to provide the details behind use tax payments to the various taxing entities. This report also summarizes the information and may be used to determine the amount to pay to the various taxing entities.
  
  
• U0449B Use Tax Disbursal Office Listing (p##_lpu0449b_rpt) reports the same detailed use tax payable information as the U0449A for each asset but, in portfolio, company, region, and office order. This report may be used to provide the detail behind the General Ledger transactions for use tax payable at the office level. This report also summarizes the office detail information and may be used to verify General Ledger transactions for use tax payable at the office level.
  
  
• U0449C Use Tax Disbursal Exception (p##_lpu0449c_rpt)shows assets for which tax processing could not be completed. It displays the Location code entered for the asset, the Asset number, the date the asset became associated with a lease, and an exception message (e.g., Location record not found).
  
  
• U0449D Non Rpt Use Tax Disbursal - Location (p##_lpu0449d_rpt) is identical to U0449A except that it only includes assets with a use tax code of NONR (Exempt and Non Reportable). These assets were not included on the U0449A report.
  
  
• U0449E Non Rpt Use Tax Disbursal - Office (p##lpu0449e_rpt) report is identical to U0449B except that it only includes assets with a use tax code of NONR (Exempt and Non Reportable). These assets were not included on the U0449B report.

The next two reports contain data when the Additional Non-Vertex Rates also known as Vehicle Tax Table is used. For detailed information, refer to Additional Non-Vertex Rates overview document.

• U0449F Vehicle Use Tax Disbursal – Location (p##_lpu0449f_rpt) is identical to the U0449A except that it only includes assets that have the Veh Tax Table selected. These assets were also included in the U0449A report.


• U0449G Vehicle Use Tax Disbursal – Office (p##_lpu0449g_rpt) is identical to the U0449B except that it only includes assets that have the Veh Tax Table selected. These assets were also included in the U0449B report.

Three additional reports are produced by this module when the Canadian Tax System is turned on.

• U0449A Canadian Use Tax Disbursal Listing (p##_lpu0449a_cand_a.rpt) reports at asset level listing the tax disbursed for Canadian jurisdictions only using Federal and Province rates.
• U0449A Canadian Use Tax Disbursal Summary (p##_lpu0449a_cand_b.rpt) reports on same assets tax information but only provides over all totals that belongs to each Canadian provinces and will be summed up to grand totals.
• U0449D Canadian Non-Rpt Use Tax Disbursal Listing (p##_lpu0449d_cand.rpt) reports at asset level listing the tax disbursed for Canadian jurisdictions only using Federal and Province rates that would have been used if taxed.

LeasePak supports XML data files for U0449A and U0449D reports. The XML data files will be stored in the LeasePak data directory once generated during end of month processing.

Use tax is disbursed either when actual payment is received from the lessee (cash basis) or when the payment is due to be received from the lessee (accrual basis). Cash basis vs. accrual basis is setup in U0212 Portfolio Assessment Customization for the Sales and Use Tax assessment.

If the taxing entity's reporting code is quarterly, a report for that taxing entity is produced during the months of March (for January, February, and March), June (for April, May, and June), September (for July, August, and September), and December (for October, November, and December).

If the Multiple Banks module is purchased, the cash account that will be credited is 127 (Sales Tax Disbursals).

Skip Notes: There is no adverse effect if this module is skipped. Use tax is disbursed by the next End of Month Use Tax Disbursal report. However, if this module is skipped, no Use Tax Disbursal report is available for tax reporting purposes. For instance, if the taxing entity's reporting code is quarterly and the March report is skipped, the next report produced is the June report.

The U0449 reports are viewable via R0929 Print/View Reports rather than U0406 Print/View Reports.

U0449A Use Tax Disbursal Location

U0449A Use Tax Disbursal Location reports at the asset level. U0449D report is identical to U0449A except that it only includes assets with a use tax code of NONR (Exempt and Non Reportable). Both reports include the following information:

• CITY NAME
  
  
• STATE RATE
  The state rate used to calculate the sales/use tax is displayed. An asterisk in this field indicates a manual sales tax assessment was performed via U0105 Assessment for the asset listed.
  
  
• CNTY RATE
  The county rate used to calculate the sales/use tax is displayed.

• CITY RATE
  The city rate used to calculate the sales/use tax is displayed.

• CO
  The number of the company is displayed.

• RE
  The number of the region is displayed.

• OFF
  The number of the office is displayed.

• LEASE
  
  
• ASSET
  
  
• NON-TAXABLE GROSS RECEIPTS
  If the asset is not taxed at the state, county or city levels, then the amount of the lease payment (gross receipts) attributed to this asset is displayed. For example, if 2 assets, both with the same acquisition cost, are assigned to one lease and the lease payment is $250.00, the gross receipts for each asset is $125.00 per lease payment. All other amounts (taxable gross receipts and tax released amounts) for this asset are zero.
  
  Non-taxable gross receipts are shown regardless of whether the accounting is done on a cash or accrual basis.

• TAXABLE GROSS RECEIPTS
  If the asset is taxed at the state, county and/or city levels, then the amount of the lease payment (gross receipts) attributed to this asset is displayed. For example, if 2 assets, both with the same acquisition cost, are assigned to one lease and the lease payment is $250.00, the gross receipts for each asset is $125.00 per lease payment. The NON-TAXABLE GRSS RECEIPTS, in this case, is zero.

• TAX RELEASED STATE
  If the asset is taxed, the amount of state taxes due this period is displayed. If the state is reported on quarterly, this amount is zero during non-quarter month ends (e.g., January, February, April, etc.), and is an accumulation for the quarter during quarter ends.

• TAX RELEASED COUNTY
  If the asset is taxed, the amount of county taxes due this period is displayed. If the county is reported on quarterly, this amount is zero during non-quarter month ends (e.g., January, February, April, etc.), and is an accumulation for the quarter during quarter ends.
  
  
• TAX RELEASED CITY
  If the asset is taxed, the amount of city taxes due this period is displayed. If the city is reported upon quarterly, this amount is zero during non-quarter month ends (e.g., January, February, April, etc.), and is an accumulation for the quarter during quarter ends.

• TAX RELEASED TOTAL
  If the asset is taxed, the total amount of state, county and city taxes due and payable for the asset is displayed.

U0449B Use Tax Disbursal Office

U0449B Use Tax Disbursal Office reports at the asset level. Report U0449E is identical to U0449B except that it only includes assets with a use tax code of NONR (Exempt and Non Reportable). Both reports contain the following information:

• ST
  The 2-character post office abbreviation for the state is displayed.

• CNTY
  The 4-character code (as specified through U0701 Location) for the county is displayed. For locations outside the U.S., CNTY is blank.
  
  
• CITY
  
  
• LEASE
  
  
• ASSET
  
  
• NON-TAXABLE GRSS RECEIPTS
  For all assets not taxed at the state, county or city levels, the amount of the lease payment (gross receipts) attributed to these assets is displayed. For example, if two assets, both with the same acquisition cost, are assigned to one lease and the lease payment is $250.00, the gross receipts for each asset is $125.00 per lease payment. All other amounts (taxable gross receipts and tax released amounts) for these assets are zero.

• TAXABLE GRSS RECEIPTS
  For all assets taxed at the state, county and/or city levels, the amount of the lease payment (gross receipts) attributed to these assets is displayed. For example, if two assets, both with the same acquisition cost, are assigned to one lease and the lease payment is $250.00, the gross receipts for each asset is $125.00 per lease payment. The NON-TAXABLE GRSS RECEIPTS, in this case, is zero.

• TAX RELEASED STATE
  For all assets taxed, the amount of state taxes due this period is displayed. If the state is reported upon quarterly, this amount is zero during non-quarter month ends (e.g., January, February, April, etc.), and is an accumulation for the quarter during quarter ends.

• TAX RELEASED COUNTY
  For all assets taxed, the amount of county taxes due this period is displayed. If the county is reported upon quarterly, this amount is zero during non-quarter month ends (e.g., January, February, April, etc.), and is an accumulation for the quarter during quarter ends.

• TAX RELEASED CITY
  For all assets taxed, the amount of city taxes due this period is displayed. If the city is reported upon quarterly, this amount is zero during non-quarter month ends (e.g., January, February, April, etc.), and is an accumulation for the quarter during quarter ends.

• TAX RELEASED TOTAL
  For all assets taxed, the total amount of state, county and city taxes due and payable for these assets is displayed.

U0449C Use Tax Disbursal Exceptions

The Use Tax Disbursal Eceptions report U0449C reports at asset level and includes the following information:

• Key
  

• Exception
  The exception message is displayed.
  
  

U0449D Non RPT Use Tax Disbursal Location

U0449D Non RPT Use Tax Disbursal - Location is identical to U0449A except that it reports assets with a use tax code of NONR (Exempt and Non-Reportable) which were not included in the U0449A.

U0449E Non RPT Use Tax Disbursal - Office

U0449E Non RPT Use Tax Disbursal - Office is identical to U0449B except that it reports assets with a use tax code of NONR (Exempt and Non-Reportable) which were not included in the U0449B.

U0449F Vehicle Use Tax Disbursal - Location

U0449F Vehicle Use Tax Disbursal – Location is identical to U0449A except that it reports only assets which have the Veh Tax Table switch turned on. These assets have been included in the U0449A report as well.

U0449G Vehicle Use Tax Disbursal - Office

U0449G Vehicle Use Tax Disbursal – Office is identical to U0449B except that it reports only assets which have the Veh Tax Table switch turned on. These assets have been included in the U0449B report as well.

U0449A-A CANADIAN USE TAX DISBURSAL - LISTING

U0449A-A Canadian Use Tax Disbursal - Listing reports at asset level listing the tax disbursed for Canadian jurisdictions only using Federal and Province rates. U0449A-A Canadian Use Tax Disbursal - Listing report includes the following information:

• PROVINCE NAME


• FEDERAL TAX TYPE
  GST/HST


• PROVINCIAL TAX TYPE
  PST/QST/RST


• CITY NAME
  Province name.


• FEDERAL RATE
  The Canadian federal rate (GST/HST) used to calculate the sales/use tax is displayed.


• PROVICINAL RATE
  The provincial rate used to calculate the sales/use tax is displayed.


• CO
  The number of the company is displayed.


• RE
  The number of the region is displayed.


• OFF
  The number of the office is displayed.


• LEASE


• ASSET


• NON-TAXABLE GROSS RECEIPTS
  If the asset is not taxed at the federal and provincial level, then the amount of the lease payment (gross receipts) attributed to this asset is displayed.


• TAXABLE GROSS RECEIPTS
  If asset is taxed at the federal and provincial level, then the amount of the lease payment (gross receipts) attributed to this asset is displayed.


• TAX RELEASED FEDERAL
  If the asset is taxed. The amount of Canadian federal) taxes due this period is displayed. If the Canadian federal amount is reported on quarterly basis, this amount is zero during non-quarter month ends (e.g., January, February, April, etc.), and is an accumulate for the quarter during quarter ends.


• TAX RELEASED PROVINCIAL
  If asset is taxed, the amount of Canadian province (city) taxes due this period is displayed. If the Canadian province is reported upon quarterly, this amount is zero during non-quarter month ends (e.g., January, February, April, etc.), and is an accumulation for the quarter during quarter ends.


• TAX RELEASED TOTAL
  If the asset is taxed, the total amount of Canadian provincial and federal taxes due and payable for the asset is displayed.

The Tax Type fields will always display the latest information saved in RST table record(s).

U0449A-B CANADIAN USE TAX DISBURSAL - SUMMARY

U0449A-B Canadian Use Tax Disbursal - Summary reports on same assets tax information but only provides over all totals that belongs to each Canadian province and will be summed up to grand totals. U0449A-B Use Tax Disbursal Summary- Summary report includes the following information:

• PROVINCE NAME


• PROVINCE NAME
  


• FEDERAL TAX TYPE
  GST/HST


• PROVINCIAL TAX TYPE
  PST/QST/RST


• FEDERAL TAX RATE
  The Canadian federal tax rates used to calculate the sales/use tax is displayed.


• PROVICINAL TAX RATE
  The Canadian province tax rates used to calculate the sales/use tax is displayed.


• NON-TAXABLE GROSS RECEIPTS
  If Canadian asset is not taxed at the provincial or federal level, then the amount of the lease payments (gross receipts) attributed to this asset is displayed.


• TAXABLE GROSS RECEIPTS
  If Canadian asset is taxed at the federal or provincial levels, then the amount of the lease payment (gross receipts) attributed to this asset is displayed.


• TAX RELEASED FEDERAL
  If Canadian asset is taxed, the amount of the federal taxes due this period is displayed.


• TAX RELEASED PROVINCIAL
  If Canadian asset is taxed, the amount of the province (city) taxes due this period is displayed.


• TAX RELEASE TOTAL
  If Canadian asset is taxed, the total amount of the federal and provincial taxes due and payable for the asset is displayed.


• GRAND TOTAL
  The summed up amount of all provinces and federal level asset taxes payable is displayed for non-taxable gross receipts, taxable gross receipts, tax release federal tax release provincial, Tax release total.

The Tax Type fields will always display the latest information saved in RST table record(s).

U0449D Canadian Non-Rpt Use Tax Disbursal Listing

U0449D Canadian Non-Rpt Use Tax Disbursal Listing reports at asset level listing the tax disbursed for Canadian jurisdictions only using Federal and Province rates that would have been used if taxed.

• PROVINCE NAMEProvince name with province code in parentheses is displayed.


• FEDERAL TAX TYPE
  The federal tax type code and corresponding rate are displayed.


• PROVINCIAL TAX TYPE
  The provincial tax type code and corresponding rate are displayed.


• CITY NAME
  City name is displayed.


• FEDERAL RATE
  The Canadian federal tax rate used to calculate the sales/use tax is displayed.


• PROVICINAL RATE
  The Canadian province tax rate used to calculate the sales/use tax is displayed.


• COM
  The number of the company is displayed.


• REG
  The number of the region is displayed.


• OFF
  The number of the office is displayed.


• LEASE


• ASSET


• NON-TAXABLE GROSS RECEIPTS
  If Canadian asset is not taxed at the provincial or federal level, the amount of the lease payments (gross receipts) attributed to this asset is displayed.
• TAXABLE GROSS RECEIPTS
  If Canadian asset is taxed at the federal or provincial level, the amount of he lease payment (gross receipts) attributed to this asset is displayed.


• TAX RELEASED FEDERAL
  If Canadian asset is taxed, the amount of the province taxes due this period is displayed.


• TAX RELEASED PROVINCIAL
  If Canadian asset is taxed, the total amount of the federal and provincial taxes due and payable for the asset is displayed.


• TOTAL
  The total of a province calculated is displayed.


• GRAND TOTAL
  The summed up amount of all provinces and federal level asset taxes payable is displayed for non-taxable gross receipts, taxable gross receipts, tax released federal and tax released provincial.