Accounts Payable: Custom Reports Available

File Name Description Select Input Output
Apcus01  

Unpaid invoicesall invoices,all paid bycheck #, manually select

Checking acct code, include manual checks,beginning due date, ending due date,warrant number

Vendor, invoice #,purchase amt, disc,paid amt, check #,check date

Apcus02

Same as 01, except added option of running manual check register

   

Vendor, invoice date,account, amount, check # and date

Apcus03

Same as 02, except can specifysingle or all funds.

   

Vendor, invoice date,account, amount,check # and date

Apcus04

Assign claim numbers to each invoice orprint abstract, assumes a voucher number is assigned

 

Abstract: voucher range, paid unpaid or both, order by account claim or vendor

Vendor, vendor address,claim number,account,amount and check number
Apcus05   Invidual or all vendors
Beginning check date and ending check date Vendor code, vendor name,invoice date, amount, amount paid, check number and date
Apcus06 Invoice Edit List Invoices not posted to GL or all unpaid invoices, all or individual checking accounts Start due date, end due date, vendor or company name order Vendor, due date, checking account, account number, invoice amount and description
Apcus07 Check register report Single or all checking account codes, individual or all vendors Starting and ending date Vendor number,vendor name, invoice date, invoice number, check amount, check number and date and memo/description
Apcus08 Check warrant report Checking account code,include manual checks Beginning check number, ending check number and warrant report number Check number, vendor/company,invoice description, check date, amount paid and account number
Apcus09 Check warrant report Check date   Check number, date, vendor, invoice number, paid amount, signature area
Apcus10 Check warrant report-groups by general ledger account number Unpaid invoices, all invoices, all paid invoices by check number, manually select invoices or manual check register Checking account code,include manual checks, beginning check number, ending check number,beginning due date, ending due date and warrant report number. Vendor, invoice number, purchase amount, discount amount, paid amount and reference account

Apcus11

 

Apcus11a

Special Ed cost accounting, uses voucher number field to report special ed expenses

 

7 Character filter and date and paid range

Student ID placed in voucher field

 

Disability code range, check date range, include participant details, account detail, invoice detail

 

 

Account, description, vendor name, check date and amount paid

 

 

Apcus12 Single line vendor report All , individual or selected vendors Order by vendor number or company name Vendor number, vendor address, city, state and zip
Apcus13 Invoice edit list Invoices not posted t o general ledger or all unpaid invoices Individual or all checking accounts, start due date, end due date Vendor code, vendor name, description, account number and invoice amount
Apcus14 Vendor file report All, individual or selected vendors Vendor number or company name order Vendor name, company name, contact, address, city, state, zip and phone number
Apcus15 Check register by general ledger department or range of departments Due date or check number, checking account code Include manual checks, beginning check number, ending check number, fund range or department range Check number, check date, vendor, po number, invoice number and account number
Apcus17 Check register Due date or check number Checking account code, include manual checks, beginning check number, ending check number Check number, check date, vendor, po number, invoice number, account number, po amount and check amount
Apcus18 Check register-requires NJ school account number Checking account code Include manual checks, beginning check number, ending check number Check number, check date, vendor, invoice number, account number,amount paid and po number
Apcus19 Check register paid from each checking account and general ledger number to debit   Individual or all vendors, beginning check date, ending check date Vendor, company name, invoice date,invoice description, account number, amount paid, check number and check date
Apcus21 Employee course reimbursement Assumes voucher field filled with 'CR' Invoice date range Vendor number, payee name, memo and amount
Apcus2/2 Custom folder labels Labels as entered, label for one vendor, selected vendor label, label for all vendors or label for label code   Vendor ID, company name and fiscal year
Apcus23
Vendor activity report
  Individual or all vendors, beginning invoice date, ending invoice date PO #, vendor number, vendor name, invoice description, budget account, invoice #, check #, amount and outstanding
Apcus24 Invoice report by fund and department   Due date or check number, checking account code, date or check number range, sort and subtotal by vendor,fund and department range Due date, vendor code, company name, po number, invoice number, account number, po amount and invoice amount
Apcus25 Numeric payments list   Beginning check date, ending check date, order by account or vendor Vendor, company name, invoice, account, description, amount, check number and date paid
Apcus26 Account number report   Beginning check date, ending check date, account number Vendor code, company name, invoice number, account, description, amount, check number and date paid
Apcus27 Warrant/invoice report   Warrant report number, due date or check number, checking account code, date or check range, edit authorization section

Vendor number, po#, invoice #, invoice description, account number, account description, po amount, invoice amount, check #

 

Apcus28 Monthly claims report by fund   Paid or unpaid invoices,check date range(if paid) Vendor, description, amount. Subtotals by each fund and totals all funds
Apcus29 Purchase journal by account number   Posted ro current balance,status(open, partial, closed, all), include po's(current, last or next year), starting order date, ending order date Account #, account description, company name, po# po date, status and posted amount
Apcus30 MA sites-due date edit tool   Individual or all vendors, edit screen pops up, edit due date, company and invoice number  
Apcus31 Check warrant by fund Unpaid invoices, all invoices, all paid invoices by check number,manually select invoices or manual check register Checking account code,include manual checks,beginning due date, ending due date, check warrant number Vendor, invoice date, account, amount, check number and check date
Apcus32 Purchase order journal   Sort by vendor name or po #, starting order date, ending order date

Po #, po date, vendor number, vendor name, po amount

Apcus33 File folder labels Labels as entered, labels for one vendor, selected vendor labels, labels for all vendors or labels for label code   Vendor code,company name, fiscal year
Apcus34 Check warrant report All invoices, all invoices by check number, manually selected invoices,manual checks Checking account code, include manual checks, beginning due date, ending due date, warrant number Vendor number,invoice date, account number, amount, check number and check date
Apcus35 General ledger distribution report Unpaid invoices,paid invoices or AP as of date Individual, range or all batches,account number or batch number order Account number, vendor number,vendor name, description, po number, invoice number, invoice date, amount and batch number
Apcus36 Purchase order distribution report-by fund   Unreceived,received/no invoice or both

Account number,vendor name, description, po number, item description extended amount

Apcus37 Paid to vendors by account for check dates   Account number, starting check date, ending check date Account number, vendor number, vendor name, po number,check number, check date and amount
Apcus38 Invoice edit list Invoices not poste to general ledger or all unpaid invoices Individual or all checking accounts, start due date, end due date, order by vendor number or company Vendor code, vendor name, invoice number, po number, invoice amount, invoice date, disencumber amount, due date, checking account, discount amount
Apcus39 Check warrant account status report Unpaid invoices by date range, all invoices in date rante, paid invoices by check number Checking account code, include manual /direct pays, earliest due date,latest due date Account number, vendor number,company name, description, current budget, year to date reamining
Apcus40 Check warrant Unpaid invoices, all paid invoices by check number,manually select invoices, manual / direct pay register Checking account code, include manual/ direct pays, beginning due date, ending due date,warrant report number,include invoice memos, order by vendor number or company code Vendor, invoice number, purchase amount, discount amount,paid amount, check number and check date
Apcus41 Check summary report   Beginning check date, ending check date Vendor number, company name, paid amount, 1099 amount
Apcus42 Warrant report Unpaid invoices, all paid invoices by check number,manually select invoices, manual / direct pay register Checking account code, include manual/direct pays, beginning due date,ending due date,warrant report, include invoice memos, order by vendor number or company name, edit authorization section Vendor, invoice number, purchase amount, discount amount,paid amount,check number, check date, warrant authorization for signatures
Apcus43 General ledger reference report   Starting check date, ending check date, account number selection(you may enter multiple accounts) Account number, vendor number, check number, check date, invoice number, invoice date and amount
Apcus44 Review statement from vendor   Vendor code and invoice number Display of invoice information fot that vendor to verify statement from vendor

© NEMRC 2010-2022 | Privacy Policy