Accounts Payable Export

Use the Accounts Payable Export report to download accounts payable data to a Microsoft Excel spreadsheet file or other file format.

Contents

Column	Description
Vendor	This column displays the vendor identifier.
Vendor Name	This column displays the vendor's name.
Invoice Date	This column displays either the invoice date or the cash receipt date.
Invoice Number	This column displays the invoice number.
Voucher Date	This column displays the voucher date.
Voucher	This column displays the voucher number.
Vendor Pay Terms	The payment terms can be any of the following: Date: Payment is processed on the date specified. Next: Payment is processed in the next check processing run. Hold: Payment is on hold. Pay When Paid (PWP): Payment is processed with the next check processing run your company receives full payment for the client charges associated with the vouchers.
Voucher Payment Date	This column displays the payment date.
Voucher Liab Code	This column displays the accounts payable liability code to which this voucher was posted. The liability code enables you to identify the account that receives the implicit posting when a voucher is posted. The liability code defines the credit posting in the general ledger. If your firm uses organizations, and you maintain separate Balance Sheets by organization, the liability code also links the transaction to an organization code.
Voucher Bank Code	This column displays the code for the bank involved in the transaction.
Voucher Line	This column displays the line number for each item on the voucher.
Description	This column displays descriptive text for the line item.
Project	This column displays the project associated with the voucher.
Phase	This column displays the phase associated with the voucher.
Task	This column displays the task associated with the voucher.
Payment Currency Code	This column displays the payment currency code associated with the voucher.
Bank Currency Code	This column displays the bank currency code associated with the voucher.
Voucher Account Number	This column displays the account number for the DPS account associated with this voucher If the project is a regular project, this is a reimbursable expense account or a direct expense account. If the project is an overhead project, this is an indirect expense account.
PWP Code	This column displays the status of each pay when paid (PWP) voucher: NF: Not found. This status indicates that you posted the voucher, but the voucher is not yet associated with a final invoice for the project, or is not associated with a final invoice at the appropriate level. This status only appears for vouchers marked as PWP. NP: Not paid. This status indicates that you have accepted the final invoice and posted the resulting invoice file that contains the PWP voucher, but you have not been paid for the invoice by your client. PD: Paid. This status indicates that you posted the cash receipt for the invoice that contained the voucher. The voucher is available for payment processing.
Check Ref No	This column displays the check number.
Check Date	This column displays the check date.
Voucher Amount	This column displays the total amount of the voucher.
Voucher Previous Payments	This column displays previous payments for the voucher.
Voucher Discount	This column displays the amount of discounts taken to date.
Voucher Balance	This column displays the balance owed to the vendor.
Voucher Trans Type	This column displays a two-letter code for the type of transaction.
Voucher Sub Trans Type	This column displays a one-letter code for the transaction sub-type (for example, A for automatic check, C for disbursement check, or V for voided check).
Voucher Billed Invoice	This column displays the number of the invoice on which the record was final billed.
Billed Project	This column displays the project for which the record was final billed.
Billed Phase	This column displays the phase for which the record was final billed.
Billed Task	This column displays the task for which the record was final billed.
Vendor Sort Name	This column displays the name by which you want to sort the report. This name may not be the same as the name in Vendor Name.
Vendor Type	This column displays the vendor type (for example, Trade, Consultant, or Employee).
Vendor Status	This column displays the vendor's status (for example, Active, Inactive, or Dormant).
Vendor Organization	This column displays the organization for which this vendor provides goods or services.
Payment Type	This column displays the three payment type options: Check/EFT, Wire, or Direct Deposit.
Reference Number	This column displays the reference or confirmation number for wires or direct debits.
Wire Fee Account	This column displays the name of the wire fee account.
Wire Fee Project	This column displays the name of the wire fee project.
Wire Fee Phase	This column displays the name of the wire fee phase.
Wire Fee Task	This column displays the fee charged by the bank that is handling the wire transaction.
Wire Fee	This column displays the name of the wire fee.
Payment Memo	This column displays any additional wire or direct debit payment data information.
Bank Name	This column displays the bank's name.
Bank Address 1-4	These columns displays the bank's address.
Bank City	This column displays the bank's city.
Bank State	This column displays the bank's state.
Bank Zip	This column displays the bank's zip code.
Bank Country	This column displays the bank's country.
Bank Account ID	This column displays the bank's account ID.
Bank Account ID Type	This column displays the bank's account ID type.
Bank ID	This column displays the bank's ID.
Bank ID Type	This column displays the bank's ID Type.
Bank Payment Amount	This column displays the bank's payment amount.
Bank Exchange	This column displays the bank's exchange rate.
Bank Amount	This column displays the bank amount.
Bank Totals	This column displays the total of the selected vouchers.