Reports for Colombia
In addition to the reports specified as part of a process in other sections of this implementation guide, these reports exist for Colombia.
Report ID and Report Name |
Description |
Navigation |
|---|---|---|
R04701 AP Orig Doc to GL Batch Integrity Report |
The A/P Orig Doc to G/L by Batch Integrity report (R04701) verifies that the gross amount of each batch in the F0411 table is in balance with the amounts in the corresponding batch in the F0911 table and prints any discrepancies. When processing vouchers in Colombia, the system overrides the standard calculation of the Amount to Distribute field if the voucher includes a tax explanation code of C or CT. This override is done to comply with Colombian regulations, but causes discrepancies between the F0411 and F0911 tables. The R04701 has been updated for Colombia so that the report no longer lists these differences as errors when the logged on user has the country code for Colombia in their user profile. |
Period End Processing (G0421), A/P Orig Doc to G/L by Batch |
R76C0001 Rent Withholding |
Use version ZJDE0001 to view rent withholding certificates, version ZJDE0002 to view rent withholding by GL offset, and version ZJDE0003 to view rent withholding by tax area. The Colombian Tax Authority (DIAN), according to Decreto 862, has made a withholding tax applicable to all companies and individuals that are subject to Equity Income Tax – CREE (Impuesto Sobre la Renta para la Equidad). The withholding agency calculates the withholding while validating invoice. As a proof of the withholding amount, the withholding agent must issue a certificate in Spanish and in domestic currency to the person or company subject to the withholding. The Rent Withholding report prints the CREE Withholding Certificate by year, month, day, company, supplier, or by operation based on the settings in processing options. When you run the Rent Withholding report, it is important to define data selection for the type of withholding tax to be printed on the certificate. The Rent Withholding report prints CREE withholding based on the line number specified during data selection. For example, if the tax area setup of CREE withholding is in the fifth bucket, you must sepcify the value of Line Number in data selection as .005. |
Tax Reports (G76C13), Rent Withholding |
R76C0002 Withholdings Report |
Use version ZJDE0001 to view withholding transactions by document and version ZJDE0002 to view withholding transactions for which payment was made to a third-party. |
Tax Reports (G76C13), Withholdings Report |
R76C0003 VAT Withholding |
Use version ZJDE0001 to view VAT withholding by account, version ZJDE0002 to view VAT withholding by GL offset, and version ZJDE0003 to view VAT withholding by tax area. |
Tax Reports (G76C13), VAT Withholding |
R76C0004 Timbre Withholding |
Use this report to print the withholding certificate. |
Tax Reports (G76C13), Timbre Withholding |
R76C0005 Auto-Withholding Calculation |
Use this report to process invoices from the F03B11 table that is created by the A/R Invoice Entry application or Sales Update process. This report calculates the Auto-Withholdings of an invoice, and stores them as Tax Explanation Code (VT) lines in the F03B11 table. |
Tax Reports (G76C13), Auto-Withholdings Calculation |
R76C0006 Additional Tax Calculation (Release 9.2 Update) |
This report will add tax lines to Account Payable (F0411) table and the localized Tax Detail-Wrokfile table (F76CUI02) for the Tax Areas defined in the Tax Area Relationship Setup program (P76C0005). The Additional Tax Calculated (F76C0006) table contains information about the additional tax calculated. |
Tax Reports (G76C13), Additional Tax Calculation AP |
R76C0911 General Journal by Category Code |
Prints balance information for category 21, 22, or 23. This report is useful for statutory accounting. |
Fiscal Books by Category Code (G76C15), General Journal by Category |
R76C0911A G/L with Total by Object Account |
Prints a daily book that has been developed according to the DIAN reports requirements. |
Fiscal Books without Category Code (G76C152), G/L with Total by Object Account |
R76C094 Inventory and Balance Sheet by Category Code |
Generates the inventory and balance fiscal book by category code. |
Fiscal Books by Category Code (G76C15), Inventory and Balance by Category Code |
R76C094B Inventory and Balance Sheet by Object Account |
Generates the inventory and balance fiscal book by account. |
Fiscal Books without Category Code (G76C152), Inventory and Balance by Object Account |
R76C0941 Trial Balance by Category Code |
Prints a report if the PUC is assigned category code 21, 22, or 23 in the chart of accounts. |
Fiscal Books by Category Code (G76C15), Trial Balance by Category Code |
R76C9411 Debits and Credits T/B by Object Account |
Prints a general ledger report by account and has been developed according to DIAN reports requirements. This report prints if the PUC is assigned category code 21, 22, or 23 in the chart of accounts. The PUC is specified in the object account. Review the data selection for this report to ensure that it corresponds to the processing options that you set for the report. For the process number, specify the next number from UDC table 76C/02. |
Fiscal Books without Category Code (G76C152), Debits and Credits T/B by Object Account |
R76C094211 G/L with Subledger Totals |
Prints only subledgers with activity during the specified period. |
Fiscal Books by Category Code (G76C15), G/L with Subledger Totals |
R76C9415B Daily Book by Complete Document |
Prints a general ledger report with debit and credit amounts. Print this report to satisfy the DIAN (Direccion de Impuestos y Aduanas Nacionales de Colombia) requirements of producing a report showing all accounting transactions with matching documents. No processing options exist for this report. |
Fiscal Books without Category Code (G76C152), Daily Book by Complete Document |
R76C9422 G/L by Object Account with Subledger Total |
This report prints a general ledger with subledger totals for active subledgers for the period specified in the processing options. The report includes previous balances by subledger. The report has been developed according to the DIAN reports requirements |
Fiscal Books without Category Code (G76C152), G/L by Object Account with Subledger Total |