Business

User Tools

Site Tools

Trace: • BAM1600 - Checked Out Inventory File Listing • FIN3250 - Trial Balance • FIN3051 - Combined Funds Board Report • FIN3100 - Budget Status Summary • Vendor PO Inquiry - FIN5100
general:bankreconciliation:maintenance:banktransactions:createtransactions:body

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
general:bankreconciliation:maintenance:banktransactions:createtransactions:body [2019/11/21 17:38] – emorenogeneral:bankreconciliation:maintenance:banktransactions:createtransactions:body [2021/01/26 19:35] (current) – emoreno
Line 1: Line 1:
-<WRAP round intro>This tab is used to extract transactions from the Finance and Human Resources tables for bank reconciliation.+<WRAP round intro>This tab is used to extract transactions from the Finance and Payroll tables for bank reconciliation.
  
 Transactions are grouped and summarized as follows:  Transactions are grouped and summarized as follows: 
Line 5: Line 5:
   * **Checks** - Vendor number, check number, check date, check void flag (voids are extracted)   * **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)   * **Payroll Checks** - Employee number, pay frequency, pay date, adjustment number (voids are extracted)
 +**Note**: The original and voided check transactions are extracted even if the two transactions have the same date. 
   * **Journal Vouchers** - JV number, JV description (the earliest date is 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): EFT payments are extracted as a JV with the following JV number (description for all is EFT Total):
Line 12: Line 13:
 An additional extract for the same Bank Account Group, Accounting Period and/or Pay Date range does not create duplicate entries. An additional extract for the same Bank Account Group, Accounting Period and/or Pay Date range does not create duplicate entries.
  
-**Note**: The original and voided check transactions are extracted even if the two transactions have the same date. +**Note**: Accounts with an **Investment Type** selected on the [[bankreconciliation:tables:bankaccountfundgroups:bankaccountgroupfunds|Bank Reconciliation > Tables > Bank Account Fund Groups > Bank Account Group Funds]] tab are not extracted.
  
 </WRAP> </WRAP>
Line 25: Line 26:
 ^Pay Date From and To|Type or select from the calendar the from and to pay dates to be used to retrieve payroll data. If you do not need payroll data, leave these fields blank. You can enter the same to and from date to retrieve data for a single date.| ^Pay Date From and To|Type or select from the calendar the from and to pay dates to be used to retrieve payroll data. If you do not need payroll data, leave these fields blank. You can enter the same to and from date to retrieve data for a single date.|
  
-{{:bankreconciliation:maintenance:banktransactions:bank_recon_create_transactions_1.jpg|Bank Reconciliation Create Transactions Tab}}  
  
 {{page>general:bank_recon_bank_acct_grp_execute}} {{page>general:bank_recon_bank_acct_grp_execute}}
Line 31: Line 31:
 {{page>general:bank_recon_bank_acct_grp_process}} {{page>general:bank_recon_bank_acct_grp_process}}
  
-Click **Cancel** to cancel the process and clear the data on the tab.+VCV Click **Cancel** to cancel the process and clear the data on the tab.
  
  
  
general/bankreconciliation/maintenance/banktransactions/createtransactions/body.1574357938.txt.gz · Last modified: 2019/11/21 12:38 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.