Payables Reports Listing
Report Name | Report Description | ||
Bank Account Listing | Use this report to review information for each internal bank account you use. Payables provides detail information about each bank, bank branch, bank account, and payment document that you have defined. | ||
Dstribution Set Listing | Use the Distribution Set Listing to review a complete list of all the Distribution Sets you have defined. Distribution Sets simplify and speed invoice entry by automatically generating invoice distributions for invoices which have assigned Distribution Sets. | ||
Employee Listing | Use this report to create a list of employees that meet criteria you specify. You can sort this report in four different ways. | ||
Payment Terms Listing | Use the Payment Terms Listing to review a complete list of the payment terms you have defined in the Payment Terms window. | ||
Payables Lookups Listing | Use this report to obtain a listing of all predefined lookup values, and all lookup values you defined in the Oracle Payables Lookups window. | ||
Tax Numbers Listing | Use the Tax Codes Listing to review rate and account information for tax codes you defined in the Tax Codes window. | ||
AP Input Tax Groups Listing | Use the Tax Groups Listing to review all tax groups and the tax codes that belong to each group. The Tax Groups Listing lists only the input tax groups that are available to the organization associated with your user responsibility. You define tax groups in the Tax Groups window. | ||
Tax Recovery Rules Listing | Use the Tax Recovery Rules Listing to review all the tax recovery rules and rates that you defined in the Tax Recovery Rules window. The reports lists all of the rates for each tax rule. | ||
Expense Report Template Listing | Use this report to review a listing of all expense report templates you define in the Expense Report Templates window. | ||
with holding tax certificate listing | |||
Payable Look up Listing | |||
ss Employee Listing | |||
Invoice Audit Listing | |||
Programs | |||
Assignment One Concurrent Program | |||
create adjusting documents in Payable Program | |||
AutoRate Program: | AutoRate uses exchange rate information in the GL Daily Rates table to enter exchange rates for any foreign currency invoices or payments that have no exchange rates. AutoRate cannot update exchange rates unless you have first defined exchange rates in the GL Daily Rates table that match the invoice or payment currency, rate date, and rate type | ||
Credit Card Invoice Interface Summary: | This program creates invoices for your procurement card issuers in the Payables Open Interface tables. This program selects all records for a given date range in AP_EXPENSE_FEED_DISTS with a status of at least Validated. The program will not select any statuses that you have specifically excluded from payment in the Card Programs window. Also, the program will not select any records that have been previously selected by the program. If you choose to summarize the transactions, the system will create a single invoice for each unique combination of GL Account and Tax Code. In addition, if you summarize the transactions, the report will display only the Line, Account, and Amount | ||
Employee Update Program: | The
Invoice Validation process checks the matching tax, period status,
exchange rate, and distribution information for invoices you enter and
automatically applies holds to exception invoices. If an invoice has a
hold, you can either manually release the hold (if allowable) or correct
the exception that caused Invoice Validation to apply the hold and
then resubmit Invoice Validation. | ||
Expense Report Import Program: | Use
Expense Report Import to create Payables invoices from expense reports
you enter in Payables or Oracle Internet Expenses. You can then use
Payables to validate and pay these invoices and create accounting
entries for them. | ||
Invoice Validation Program: | |||
Mass Additions Create Program: | Run the Mass Additions Create program to transfer capital invoice line distributions from Oracle Payables to Oracle Assets. For foreign currency assets, Payables sends the invoice distribution amount in the converted functional currency. The mass addition line appears in Oracle Assets with the functional currency amount. Oracle Assets creates journal entries for the functional currency amount, so you must clear the foreign currency amount in your general ledger manually. After you create mass additions, you can review them in the Prepare Mass Additions window in Oracle Assets. | ||
Payables Accounting Process: | |||
Payables Open Interface Import Program: | You can use the Payables Open Interface Import program to create Payables invoices from invoice data in the Payables Open Interface tables. You can populate the Payables Open Interface tables with invoice data from the following sources | ||
Payables Transfer to General Ledger Program: | This program transfers accounting entries to the GL interface. You can then use the data in the interface to create journal entries and post them in your general ledger. If you use Oracle General Ledger, you can submit Journal Import to create the journal entries | ||
Procurement Card Transaction Validation Report: | |||
Purge Payables Open Interface: | Use
the Payables Open Interface Purge Program after you submit the
Payables Open Interface Import program. This program purges records
from the Payables Open Interface tables (AP_INVOICES_INTERFACE and
AP_INVOICE_LINES_INTERFACE). Purge only invoices that you successfully
imported, or enter Yes for Purge All to purge all records in the table
that match the Source and Group program parameters you enter. | ||
Purging Records: | To optimize your database storage, you can delete Oracle Payables, Oracle Purchasing, and Oracle Supplier Scheduling records that you no longer need to access online. You can also purge invoices, purchase orders, suppliers, and related records such as invoice payments, supplier schedules, and purchase receipts. | ||
Supplier Merge Program: | |||
Unaccounted Transactions Sweep Program: | The Unaccounted Transactions Sweep Program transfers unaccounted transactions from one accounting period to another. The program redates all accounting dates of all unaccounted transactions to the first day of the open period you specify. Because you cannot close a Payables period that has unaccounted transactions in it, if your accounting practices permit it, you might want to use this program to redate transaction accounting dates to another open period. You can then close the accounting period from which Payables moved the invoices and payments. | ||
Unapply Preupgrade Prepayments Program: | |||
Update Income Tax Details Utility and Report: | Submit this utility to report on or update the Income Tax Type and/or Income Tax Region fields on invoice distributions. These fields are required for all invoice distributions of United States Federally Reportable suppliers because the fields are necessary for 1099 reporting. You can correct inaccurate or missing Income Tax Type or Income Tax Region fields for 1099 suppliers. First, ensure that the supplier has accurate 1099 information (Income Tax Type and Income Tax Region), then submit the utility. | ||
Update Matured Future Payment Status Program: | |||
Supplier Reports | |||
Invalid PO Supplier Notice: | Use the Invalid PO Supplier Notice to create a notice informing a supplier that you placed an invoice on hold because the supplier did not provide a purchase order number for matching or you could not use the purchase order number provided by the supplier. Payables creates a notice for each supplier with invoices to which you have manually applied an Invalid PO hold | ||
Purchase Order Header Updates Report: | Use the Purchase Order Header Updates Report to review purchase orders updated by the Supplier Merge program | ||
Supplier Audit Report: | Use the Supplier Audit Report to help identify potential duplicate suppliers. For example, you enter a supplier named Oracle Corporation, and another supplier named Oracle Corp. This report lists active suppliers whose names are the same up to a specified number of characters. The report ignores case, spaces, special characters, etc. | ||
Supplier Customer Netting Report (Oracle Receivables User Guide) | This report displays the net balance in Oracle Payables and Oracle Receivables for any Suppliers and Customers who have the same name, NIF Code, or VAT Registration. For example, if you sell to Kline Manufacturing, but you also purchase goods from them, they are considered both a customer and a supplier | ||
Supplier Mailing Labels: | Use this report to create mailing labels for supplier sites. You can order your labels by supplier or by postal code. You can print mailing labels for any of your supplier’s active sites. | ||
Supplier Merge Report: | The Supplier Merge Program is a utility you can use to maintain your supplier records. You can use it to merge duplicate suppliers into a single, consolidated supplier. You can use it to merge transactions within the same supplier from one supplier site to a different suppler site. You can choose to merge all transactions for a suppler into a new supplier, or you can just choose to merge unpaid invoices. This option is useful in the case of an acquisition. In that case you may want to leave all of the transaction history with the original supplier and only merge unpaid invoices to the new supplier who now wants to receive the payments | ||
Supplier Open Balance Letter: | Use this report for auditing purposes or to periodically inform your suppliers of open balances. This letter contains an introductory paragraph, individual transaction information, and the outstanding balance due for a supplier site as of a specific date | ||
Supplier Paid Invoice History Report: | You can submit the Supplier Paid Invoice History Report by supplier or supplier type to review payment history, discounts taken, and frequency of partial payments. The report lists supplier payments alphabetically by supplier and site. Payables separates invoice amounts paid in foreign currencies from invoice amounts paid in your functional currency by printing a subtotal of the paid invoices by currency. | ||
Supplier Payment History Report: | Use the Supplier Payment History Report to review the payment history for a supplier, or a group of suppliers with the same supplier type. You can submit this report by supplier or supplier type to review the payments you made during a time range you specify. This report provides totals for the payments made to each supplier site, each supplier, and all suppliers included in the report. If you choose to include the invoice details, Payables displays the paid invoice’s invoice number, date, invoice amount, and amount paid by the payment. This report also displays the void payments for a supplier site, but does not include the amount of the void payment in the payment total for that supplier site. | ||
Suppliers Report: | Use the Suppliers Report to review detailed information about your supplier records. You can use this report to verify the accuracy of your current supplier information and to help manage your master listing of supplier records. Payables provides detailed information for each supplier, and optionally, supplier site, including the user who created the supplier/site, creation date, pay group, payment terms, bank information, and other supplier or site information. | ||
Income Tax Forms and Reports | |||
1096 Form: | The Unted States Internal Revenue Service requires that you send a 1096 form as a summary of each 1099 form type you transmit on paper. Payables generates the report on a preformatted form from the Internal Revenue Service. When you run the 1099 Forms report, Payables summarizes all payments of 1099 MISC reportable invoice distributions and populates a table for 1096 information. You can then submit the 1096 Form report to run off this data. You can generate a 1096 form for each of your tax reporting entities. | ||
1099 Forms: | In the United States, you must report to the Internal Revenue Service certain types of payments you make to 1099 reportable suppliers. In the supplier window, you can designate suppliers as federally reportable. When you enter invoices for the supplier, you classify invoice distributions by 1099 MISC type using the Income Tax Type field. At year end, you can then report, in standard formats, your accumulated 1099 payment information to the Internal Revenue Service, other tax agencies, and your suppliers. For each reporting entity, you assign one or more balancing segment values. When you submit 1099 reports for a tax entity, Payables sums up the paid invoice distributions that have these company balancing segment values in their accounts. | ||
1099 Invoice Exceptions Report: | Use the 1099 Invoice Exceptions Report to review paid invoice distributions with inaccurate or missing 1099 income tax information. Before you run your 1099 reports, you should run the 1099 Invoice Exceptions Report for each tax entity to identify any invoice distributions that Payables will treat as exceptions in your 1099 reports. | ||
1099 Payments Report: | Use this report to review payments made to your 1099 reportable suppliers. You can use this report to reconcile to your 1099 Forms, or to prepare additional reporting. For example, you can use this report to get information needed to file 1099 reporting with states that do not participate in the combined filing program. If you need detailed information about paid invoices that are 1099 reportable, you can run the 1099 Payments Report in detail. However, if you only need basic information, such as the total amounts paid to your suppliers, you can submit the 1099 Payments Report in summary. Payables allows you to sort your 1099 payment information by supplier, income tax region, or income tax type. | ||
1099 Electronic Media: | Submit the 1099 Electronic Media report to generate your summarized 1099 information in electronic format as required by the Internal Revenue Service. You can create this file in a format to either send electronically or store on a diskette or magnetic tape to send to the Internal Revenue Service. The IRS requires electronic filing in one of these formats if you need to submit 250 or more records for your 1099 reporting. You must report 1099 information for each tax reporting entity you define for your organization, so the 250 record requirement is applicable to each tax reporting entity. | ||
1099 Supplier Exceptions Report: | Use the 1099 Supplier Exceptions Report to review suppliers with inaccurate or incomplete 1099 income tax information. You can run the 1099 Supplier Exceptions Report before you submit your 1099 reports to identify suppliers that Payables will treat as exceptions in your 1099 reports. You can correct these supplier exceptions in the Suppliers window. You should submit the 1099 Supplier Exceptions Report for each of your tax reporting entities. Payables lists the supplier name, supplier number, tax identification number, tax reporting site, state, and exception. Payables sorts this report first by supplier name and then by exception. A supplier is listed once and all exceptions under it. Since changes that need to be made are done at the supplier level, we group accordingly. Payables includes a legend at the end of this report that describes each exception. | ||
Tax Information Verification Letter: | This report generates the Tax Information Verification Letter, which requests a supplier to furnish or confirm tax information. Payables generates this standard letter for each supplier that meets the criteria you select. Payables does not generate this letter for suppliers with the Type set to Employee in the Suppliers window. | ||
Withholding Tax By Invoice Report: | Use the Withholding Tax By Invoice Report to review detailed invoice withholding tax information for a supplier, including invoice number, amount subject to withholding, and tax amounts withheld. Submit this report if your Apply Withholding Tax Payables option is At Invoice Validation Time. This report lists withholding tax information only for invoices that have amounts withheld. | ||
Withholding Tax By Payment Report: | Use the Withholding Tax By Payment Report to review detailed invoice withholding tax information for a supplier, including invoice number, amount subject to withholding, and tax amounts withheld. Submit this report if your Apply Withholding Tax Payables option is At Payment Time. This report lists withholding tax information only for invoices that have amounts withheld. | ||
Withholding Tax By Tax Authority Report: | Use the Withholding Tax By Tax Authority Report to review detailed withholding tax information for Withholding Tax type tax codes assigned to a Tax Authority type supplier. This report only lists withholding tax information for Withholding Tax type tax codes that have amounts withheld. | ||
Withholding Tax By Supplier Report: | Use the Withholding Tax By Supplier Report to review detailed invoice withholding tax information for a supplier, including invoice number, amount subject to withholding, and tax amounts withheld. Submit this report for a range of supplier names or supplier numbers. This report only lists withholding tax information for invoices that have amounts withheld. | ||
Withholding Tax Certificate Listing: | Use the Withholding Tax Certificate Listing to review withholding tax certificates for a supplier or all suppliers. Payables lists only withholding tax certificates that have been used to calculate tax amounts withheld for invoices. | ||
Withholding Tax Letter: | Use this report to create a withholding tax letter to mail to your suppliers on a periodic basis. This letter contains a list of withholdings made for a supplier, summarized either by tax type and tax rate or by supplier site. | ||
Withholding Tax Report: | Use this report to create a withholding tax report for your company’s internal reporting needs. This report contains a list of withholdings made on behalf of your suppliers, summarized either by tax type and tax rate or by supplier site, and grouped by supplier. Creating the Withholding Tax report is a two step process. In the first step, you submit the report from the Submit Request window. This step extracts your withholding tax information and stores the information in the AP_WITHHOLDING_TAX_ITF interface table. You can then publish the report either by choosing Publish RX Reports from the Submit Request window or by using a third party reporting program. | ||
Invoice Reports | |||
Accrual Reconciliation Report | The Accrual Reconciliation Report can be used to analyze the balance of the Accounts Payable (A/P) accrual accounts. You can accrue both expense and inventory purchases as you receive them. When this happens, you temporarily record an accounts payable liability to your Expense or Inventory A/P accrual accounts. When Payables creates the accounting for the matched and approved invoice, Payables clears the A/P accrual accounts and records the liability from the supplier site | ||
Actual Invoice Sweep Report | See: Unaccounted Transactions Sweep Program | ||
Batch Control Report by Batch Name See: Batch Control | Use the Batch Control reports to review invoice batches. You can run either report to review invoice entry and identify and resolve batch variances. | ||
Batch Control Report by Entered By | The report you choose determines the order in which the invoice batches are listed: • Batch Control Report by Batch Name. Lists invoice batches in order of batch name and batch date. Also sorts by entry name. • Batch Control Report by Batch Entered By. Lists invoice batches in order of entry person. Also sorts by batch name. | ||
Credit Card Outstanding Transactions Report | After importing and validating credit card transaction files, use the Credit Card Outstanding Transactions programs and reports to identify and manage transactions that were not imported and require further action. A transaction appears in any of the Credit Card Outstanding Transactions reports until the expense report to which it belongs is imported into Payables | ||
Credit Memo Matching Report: | This report lists credit memos and debit memos that match the supplier and date parameters you specify. The report lists the following for each credit memo’s distribution lines: the distribution line amount in functional currency, the distribution line GL Date, the invoice to which it is matched, and any exchange rate information. | ||
Exceptions Report (Expense Report Import Report): | Use this report to review the exceptions that occurred during the Expense Report Import process. Payables lists employee and expense report information for each expense report for which Payables did not create an invoice | ||
Expense Report Import Report: | Use this report to review detailed information for each Expense Report type invoice that Payables imports during Expense Report Import. You can also review the total number and amount of invoices that Payables successfully imported. This process creates invoices from Payables, Oracle Internet Expenses, and Oracle Projects expense reports | ||
Invoice Aging Report: | Use this report to view your unpaid invoices. This report provides information about invoice payments due within four time periods you specify in the Aging Periods window. | ||
Invoice Approval Status Report | Use the Invoice Approval Status Report to monitor invoices that are in the Invoice Approval Workflow process as of the date and time the report is run. The report also shows invoices that have completed the process because they were approved or rejected. | ||
Invoice Audit Listing by Voucher Number: | Use this report to review your invoices with assigned sequential voucher numbers. Either you or Payables can assign a unique, sequential number to an invoice during invoice entry, if you enable the Sequential Numbering profile option. | ||
Invoice Audit Listing: | Use the Invoice Audit Listing to audit invoices for duplicates. You should audit invoices periodically to ensure control of invoice payments. You can sort this listing in six different ways. For example, you may want to only audit invoices over $1000. You can specify a minimum invoice amount, and sort invoices by amount, then supplier name and date. | ||
Invoice Audit Report: | Use the Invoice Audit Report to audit invoices for duplicates. • Number of matching characters in the invoice number. For example, if you enter 5 then the first 5 characters of each invoice number must match. • (optional) same supplier name • (optional) same supplier type • (optional) same invoice date | ||
Invoice History Report: | The Invoice History Report provides information to support the balance due on an invoice. It helps you quickly identify and review a detailed list of all payment activities pertaining to a specific invoice such as gains, losses, and discounts | ||
Invoice on Hold Report: | Use the Invoice on Hold Report to identify invoices on hold. The report provides you the total number and amount (in your functional currency) of invoices on hold, which can be helpful for your accounts payable metrics. Run the Invoice Validation process before submitting this report to obtain the most up–to–date hold information. To obtain additional detail and help research invoices on matching hold, you can use the Matching Detail Report or the Matching Hold Detail Report. | ||
Invoice Register : | Use the Invoice Register to review detailed information about invoices. Payables orders the report by invoice currency and, if you use batch control, by the invoice batch name. Within the currency and batch name, the report orders by the supplier name and invoice number. | ||
Invoice Validation Report: | Use the Invoice Validation Report to review the total number of matching and variance holds that Payables applies and releases after you submit Invoice Validation. If you use budgetary control, Payables also lists any funds control holds. | ||
Matched and Modified Receipts Report: | After you automatically create invoice distributions by matching an invoice for goods to a receipt, that receipt can be modified in Oracle Purchasing. For example, you might need to adjust a receipt because the quantity received was incorrectly recorded, or the product was defective and returned to the supplier. Use this report to identify receipts that have been changed after invoice matching, and for which no users have seen modifications. | ||
Matching Detail Report: | Use this report to see the detail of how an invoice, purchase order, or receipt was matched. This report is especially helpful when an invoice is on hold and you are trying determine why the hold was placed. Data entry errors can occur during matching, and the information in this report can help in researching these problems. When you submit the report, you specify an invoice, a purchase order, or a receipt and the report shows all distributions matched to that transaction. | ||
Matching Hold Detail Report: | Use the Matching Hold Detail Report to review detailed accounts payable and purchasing information for invoices with matching holds and matching hold releases. You can print this report before initiating a payment batch to determine whether to manually release any invoices for payment. You can print this report for all invoices with matching holds and releases during a time period you specify, or you can print this report to review only invoices with matching holds applied or released since the last time you submitted Invoice Validation. | ||
Open Items Revaluation Report: | Use the Open Items Revaluation report to revalue the balances of your open items. Open items in this report are all invoices (including prepayments, credit memos, and debit memos) that are unpaid as of the last date of the revaluation period you specify. You can use the following parameters to further select which open items you want to include on the report: • Transferred to GL Only. | ||
Payables Open Interface Import Report: | |||
Prepayments Applied Report (Expense Report Import): | |||
Prepayments Status Report: | Use the Prepayments Status Report to review the unapplied prepayments and unpaid or partially paid invoices for a supplier. You can compare the invoices and prepayments for a supplier to determine if there are outstanding prepayments which you can apply against unpaid invoices. | ||
Recurring Invoices Report: | Use this report to review recurring invoice templates you defined during a specific time period. You can review this report to determine the amount you have authorized for a recurring invoice template, how much you have released, and the next amount you have scheduled. The report also lists the number of periods remaining for a recurring invoice and the next period you have scheduled. The report lists recurring invoice templates by supplier and site. | ||
Unrealized Gain/Loss Report: | Use this report to review unrealized gains and losses on foreign currency invoices. An unrealized gain or loss occurs on an unpaid foreign currency invoice when the exchange rate changes. You usually calculate unrealized gains and losses at the end of an accounting period. You may also want to submit this report whenever there is a large movement in the value of a foreign currency as compared with your functional currency. Payables orders this report by currency and supplier. The report provides you with a total for each currency and a total for all the currencies. Payables prints suppliers names alphabetically within each currency. | ||
Invoice Tax Reports | |||
Intra–EU VAT Audit Trail Report: | Use the Intra–EU VAT Audit Trail Report to review invoice and tax information for your intra–EU invoices. Intra–EU invoices are invoices that you receive from suppliers located in European Union member states other than the member state in which your organization is located. You are not required to pay Value–Added Tax (VAT) for intra–EU invoices, but you are required to maintain records and report on the VAT amounts for these invoices. Payables allows you to record these tax liabilities by creating offsetting tax amounts for each tax amount on an invoice. | ||
Tax Audit Trail Report (By Tax Code or Invoice): | Use this report to review tax information for posted or partially posted invoices you select. You can order this report either by Tax Code or Invoice. | ||
Use Tax Liability Report: | Use this report to determine the amount of use tax you owe to each tax authority for invoices you enter during a period. Payables defines Use Tax as the amount of tax a supplier should have, but did not, charge you for an invoice. You must enter a Use tax code(s) on invoice distributions for Payables to select the invoice in this report. | ||
Payment Reports | |||
Cash Requirement Report: | Use the Cash Requirement Report to forecast your immediate cash needs for invoice payments. You can submit this report before every payment batch to determine your cash requirements for the batch. You can also submit this report for the next two or three payment batches to forecast your cash requirements for the future and improve your cash management. | ||
Discounts Available Report: | Use the Discounts Available Report to identify payments where you can take advantageous discounts. If you find that you are losing discounts, you can change your system and supplier defaults and modify your payment batch selection criteria to make sure that you take all valid discounts. | ||
Discounts Taken and Lost Report: | Use the Discounts Taken and Lost report to identify payments for which you could have taken a discount, but did not. If you find that you are losing discounts, you can change your system and supplier defaults and modify your payment batch selection criteria to make sure that you take all valid discounts. | ||
E–mail Remittance Advice: | The E–mail Remittance Advice program sends remittance advice information to suppliers in e–mail format. It is not necessary to use this feature if remittance advice information is attached to your payment document. | ||
Final Payment Register: | Use the Final Payment Register to list each payment that was included in a payment batch. The report lists each payment in a payment batch, including setup, overflow, and subsequently voided payment documents, in ascending order by payment number. | ||
Future Payment Maturity Date Report: | Use this report to review the amounts and maturity dates of future dated payments that have not yet matured. This can help you estimate your cash needs by showing you the amounts of future dated payments due to mature on a specific date. Note that this report uses only the payment's maturity date, and does not use information from Oracle Cash Management to identify whether the payment has actually cleared your bank. | ||
Missing Document Numbers Report: | Use the Missing Documents Report to identify any payment documents that you have not accounted for in Payables. The report lists any payment document numbers within a range you specify that are not recorded in Payables as paid, stopped, void, or spoiled. | ||
Payment Audit by Voucher Number : | Use the Payment Audit by Voucher Number Report to review payments with assigned sequential voucher numbers. If you enable the Sequential Numbering profile option, either you or Payables can assign a unique, sequential number to each payment you create. You can also use this report to review assigned and available voucher numbers for the sequence name you specify, as well as sequential numbers that have been deleted. | ||
Payment Batch Control Report: | Use the Payment Batch Control report to review information about the invoices paid in one or more payment batches. You can submit this report after every payment batch to compare it with actual payment information. | ||
Payment Exceptions Report: | Use this report to review exception payments in Payables. This report provides you with a state–of–the–system listing of the exception payments in Payables at any time. Exception payments are payments that your bank has: • Not yet cleared • Cleared for an amount different from the payment amount • Cleared before the payment date • Cleared, but the payment is void in Payables In addition, this report lists future dated payments that: • Have not cleared and the maturity date has passed | ||
Payment Gain/Loss Report: | Use this report to identify payments that have at least one invoice with a loss and at least one invoice with a gain. The report totals the exchange rate currency gain and loss for each payment and calculates the amount you can adjust your general ledger balance for each combination of gain/loss accounts. In some accounting practices, you are required to make this adjustment to avoid inflating your gain/loss accounts. For each payment that has both a gain and a loss, Payables lists each currency exchange rate gain and loss included in the payment. | ||
Payment Register: | Use the Payment Register to review payments created for each bank account you use. The report lists each payment that has a payment date within the range you specify, as well as the total payment amount and cleared amount of all payments. It sorts and subtotals by bank, bank branch, and bank account. The report also displays the payment document and disbursement type for each set of payments, and provides a subtotal for each payment document. Voided checks will not be subtracted from the report totals. If you want to review actual cash disbursed, then you can run this report along with the Void Payment Register. | ||
Positive Pay Report: | |||
Preliminary Payment Register: | Use the Preliminary Payment Register to review the payments Payables will create when you format payments for the invoices in a payment batch. | ||
Separate Remittance Advice: | Use this report to display and print remittance advice information that is not included in your payment document (for example, electronic payment documents). You can send the output of this report to your suppliers to notify them that you made a payment and which invoices were paid. | ||
Stopped Payments Report | |||
Unclaimed Property Report: | Use this report to identify uncleared payments. This report is particularly useful in the United States where you need to identify unclaimed property that might need to be legally escheated to a designated authority. | ||
Void Payment Register: | Use the Void Payment Register to obtain a listing of void payments. The Void Payment Register provides you with payment and supplier information for each void payment. Payables sorts the report by bank, bank branch, bank account, payment document, and payment number, and prints a subtotal for each. Payables also provides a report count and total at the end of the report. | ||
with holding tax by invoice report | |||
Accounting and Reconciliation Reports | |||
• Payables Accounting Entries Report: | |||
• Accounts Payable Trial Balance Report: | Use the Accounts Payable Trial Balance Report to verify that total accounts payable liabilities in Payables equal those in the general ledger. To reconcile these balances you can compare the cumulative total liability provided by this report with the total liability provided by your general ledge | ||
• Payables Account Analysis Report: | Use this report to review and analyze accounting entries in Payables. You can use the report parameters to limit the report to just the accounting information you want to review. This report is helpful when you reconcile your accounts with your general ledger. For example, you can reconcile the prepaid expense account between Payables and your general ledger. You can submit this report in detail and compare it to an account analysis report in your general ledger. | ||
• Payables Accounting Entries Report | |||
• Payables Accounting Process Report | |||
• Period Close Exceptions Report: | Submit this report to review a complete list of exceptions that are preventing you from closing a Payables accounting period. This report lists, for each organization within the set of books, the following exceptions: • Outstanding Payment Batches • Accounting Entries not Transferred to General Ledger • Future Dated Payments Requiring Maturity Event and Accounting • Unaccounted Invoices • Unaccounted Payments | ||
• Posted Invoice Register: | Use the Posted Invoice Register to review accounting lines for invoices that have been transferred to your general ledger. Because it presents amounts that have been charged to liability accounts, this report is valid only for an accrual set of books. | ||
• Posted Payment Register: | Use the Posted Payment Register to review accounting lines for payments that have been transferred to general ledger. Because it presents amounts that have been charged to liability accounts, this report is valid only for an accrual set of books. You can submit the Posted Payment Register for one payment journal entry batch or all payment journal entry batches. | ||
• Unaccounted Transactions Report: | Use this report to identify and review all unaccounted invoice and payment transactions and see the reason that Payables cannot account for a transaction. | ||
Notices | |||
Invalid PO Supplier Notice: | Use the Invalid PO Supplier Notice to create a notice informing a supplier that you placed an invoice on hold because the supplier did not provide a purchase order number for matching or you could not use the purchase order number provided by the supplier. Payables creates a notice for each supplier with invoices to which you have manually applied an Invalid PO hold. | ||
Matching Hold Agent Notice: | Use the Matching Hold Agent Notice to print a notice informing a purchasing agent of any matching holds due to a variance between an invoice and the agent’s purchase order. When you submit this report, Payables prints a notice to each purchasing agent who has issued a purchase order that has a variance with its matched invoice. | ||
Prepayment Remittance Notice: | Use the Prepayment Remittance Notice to print a notice to a supplier with information regarding the prepayments you have applied to invoices for the supplier. The notice informs a supplier that the supplier will not receive a payment or will receive a reduced payment as a result of a prepayment application. | ||
Print Invoice Notice: | Payables prints invoice notices for each invoice that matches the selection criteria you specify in the Print Invoice Notice parameters. For detailed information on invoice notices, | ||
Receiving Hold Requestor Notice: | Use the Receiving Hold Requestor Notice to print a notice informing a requestor of an invoice hold because the requestor has not acknowledged the receipt of invoiced items. When you submit this report, Payables prints a notice to each requestor who has ordered goods or services from a supplier who has sent you an invoice, but the requestor has not yet acknowledged receipt of all items so the invoice remains unpaid. | ||
Supplier Open Balance Letter: | Use this report for auditing purposes or to periodically inform your suppliers of open balances. This letter contains an introductory paragraph, individual transaction information, and the outstanding balance due for a supplier site as of a specific date. You can run the report for supplier invoices for all currencies in which a supplier does business or for only one currency. The report summarizes balances by currency. | ||
Withholding Tax Letter: | Use this report to create a withholding tax letter to mail to your suppliers on a periodic basis. This letter contains a list of withholdings made for a supplier, summarized either by tax type and tax rate or by supplier site. |
No comments:
Post a Comment