Infolinks

Wednesday, 6 June 2012

REPORT NAMES WITH DESCRIPTION

Payables Reports Listing



Report Name      Report      Description


Bank Account ListingUse 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