This tab is used to extract transactions from the Finance and Human Resources tables for bank reconciliation.

Transactions are grouped and summarized as follows:

• Cash Receipts - Cash receipt number, date, and description
• Checks - Vendor number, check number, check date, check void flag (voids are extracted)
• Payroll Checks - Employee number, pay frequency, pay date, adjustment number (voids are extracted)
• Journal Vouchers - JV number, JV description (the earliest date is extracted)

EFT payments are extracted as a JV with the following JV number (description for all is EFT Total):

• Vendor EFT: EFT-mmddyy where mmddyy is the month/day/year of the check date.
• Payroll EFT: PAY EFT-mmddyy where mmddyy is the month/day/year of the pay date.

Payroll transfer transactions are extracted as a JV. An additional extract for the same Bank Account Group, Accounting Period and/or Pay Date range does not create duplicate entries.