Business

User Tools

Site Tools

Trace: • Employment Statistics Survey - HRS5410 • body • Extra Duty - HRS2300 • body • employmentinfo
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 [2018/10/19 14:49] – 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 11: Line 12:
 Payroll transfer transactions are extracted as a JV. 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. An additional extract for the same Bank Account Group, Accounting Period and/or Pay Date range does not create duplicate entries.
 +
 +**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 20: Line 24:
 ^GL File ID|Click {{:images:dropdown.gif|Drop-down Arrow}} to select a general ledger file ID. This field is required. | ^GL File ID|Click {{:images:dropdown.gif|Drop-down Arrow}} to select a general ledger file ID. This field is required. |
 ^Accounting Period|Type the accounting period to be used. The leading zero is not required. Or, click {{:images:acct_period_image.png|Account Period Selection Scroll Arrows}} to select an accounting period. Only one accounting can be used at a time. If this field is not populated, Finance data is not retrieved.| ^Accounting Period|Type the accounting period to be used. The leading zero is not required. Or, click {{:images:acct_period_image.png|Account Period Selection Scroll Arrows}} to select an accounting period. Only one accounting can be used at a time. If this field is not populated, Finance data is not retrieved.|
-^Pay Date From and To fields|Type or select from the calendar the from and to pay dates to be used. You can enter the same to and from date to retrieve data for a single date. If the pay date fields are not populated, Human Resources data is not retrieved.|+^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.|
  
-++++Image| {{: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 28: 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.1539960570.txt.gz · Last modified: 2018/10/19 09:49 (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.