In Mexico the value added tax (known as IVA) is payable based on when the transaction has been paid for rather than based on the transaction’s closing date.
For RAs with a balance due, the IVA tax needs to
credit a IVA Pending G/L account.
For RAs that were paid in full with a non-receivable FOP, the IVA tax needs to
credit an IVA Payable GL account.
The purpose of this program is to provide a report used to prepare a General Journal entry for the two IVA GL accounts for closed RAs.
Like the Accounting DBR, the Pending IVA Tax Report reads the RA Charge File for posted records with a DBR date and location matching the selection criteria and their deposit/payment records having dates that also fall within the requested date range.
The following data prints on the report:
|
Column |
Description |
|
A |
Location |
|
B |
RA number |
|
C |
Tax Document number |
|
D |
IVA tax percentage |
|
E |
FOP code (or the word “Balance” for any A/R balances) |
|
F |
Deposit amount, voucher amount, or amount of balance due |
|
G |
IVA (Mathematical calculation
using amounts from Columns F and D) Example:Payment of 50.00 with a 15% IVA = 50.00 – (50/1.15) 50.00 – 43.48 = 6.52IVA tax |
If more than one FOP of the same FOP type appears on the same RA, the second and subsequent FOPs will appear on the next lines starting with Column E.
Columns F and G are subtotaled after each change in the first and second level sorts (see Field 4 below.)
To access the Pending IVA Tax Report, type DBRA (RET) at any menu "OPTION:" field or the appropriate line number on the Additional Accounting Programs submenu of the Rental Accounting menu. The screen will then display:
| OPTION: __ PENDING IVA TAX REPORT 1 Open Location TUS 2 Start DBR Date EARLIEST 3 End DBR Date LATEST 4 Sort Order 1 5 Detail/Summary D 6 Print/Display P Printer: dev/tty 1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8 |
Enter data as follows:
|
1.LOCATION |
Enter: 1. Up to 6 alphanumeric characters to select a single location where RAs were opened. 2. A Group Name representing several locations (see the Chapter Edit Group Names for a discussion on location groups). Remember, the first character of a Group Name is the plus sign "+". 3. Press RETURN to default to ALL locations. EXAMPLE:Type TUS(RET) |
|
2. START DBR DATE |
Using your selected date format, enter the Starting DBR Date. Press RET to default to “EARLIEST”. EXAMPLE:Type 010108(RET |
|
3. END DBR DATE |
Using your selected date format, enter the Ending DBR Date. Press RET to default to “LATEST” (today). EXAMPLE:Type 013108 (RET) |
|
4. SORT ORDER |
The data is sorted as follows: First level sort: By the IVA tax percentage Second level sort: By the FOP Type
Third level sort: The FOP Code. For the Fourth level sort, enter 1 alpha character as shown below:
EXAMPLE: Type 1 (RET) |
|
5. DETAIL/ |
Enter 1 alpha character to select the report format. D= Detailed Report S = Summary Report; only the subtotals for Columns F and G are shown. EXAMPLE: Type D(RET) |
PRESS "F1" AT "OPTION:" TO BEGIN.