Balancing a Payroll Work File - Deposit/Distribution Account Balancing

Check out the video related to this topic: Posting a Payroll (More videos below!)

Description

Use this field to search for a specific record using the criteria listed in the Search By field. Depending on how the Payroll Group was set up, this could be an employee name, SSN, or other text (such as a clock number) used for sorting and searching for records. Enter the item you wish to see and use Enter. The list will scroll to the first item that matches.

This column shows the account number to which the payroll deposit will be made, and from which distributions to other accounts (if any) will be taken.

This field is used only by credit unions which process base payrolls. This field shows the priority in which deposits will be made to base accounts, for members which have multiple base deposit records. This is used primarily for reference, to aid the credit union in determining to which accounts funds should be distributed first, in case a member's check is short.

SEE ALSO: Understanding Payroll Deduction - "Base Payrolls" vs. "Distributed Payrolls"

For base deposit items, this column indicates the type of account to which funds are being distributed:

SH Share 
SD Share Draft 
IR IRA
TX Tax Escrow
LN  Loan (Closed-End)
OC Open Credit

(Shown on one view only; use F2-Dist Toggle to toggle between views.) This column shows any accounts to which distributions will be made from a member's base account. Some members will not have any distribution accounts, while others may have multiple distributions.

• NOTE: Changes to the Current Amount for these distribution items can be made only if the Allow Distribution Maintenance parameter for the Payroll Group allow it. If necessary, use F6-Maintenance to perform maintenance on the distribution amounts.

(Shown on one view only; use F2-Dist Toggle to toggle between views.) This column shows the priority of distributions for any members that have multiple distributions configured. This is designed to aid the credit union in determining how funds should be distributed, if a member's payroll amount is under or over the normal amount.

• For example, the member might want to transfer funds to a loan account first, then a checking account. If funds are short, the loan amount should be satisfied first.

(Shown on one view only; use F2-Dist Toggle to toggle between views.) For distribution items, this column indicates the type of account to which funds are being distributed:

SH Share
SD Share Draft
IR IRA
TX Tax Escrow
LN  Loan (Closed-End)
OC Open Credit

(Shown on one view only; use F2-Dist Toggle to toggle between views. This field is shown only if the Default Processing View for this Payroll Group is set to Search Field or Account Number.) This column shows the contents of the Special Search field for each base deposit record.

(Shown on one view only; use F2-Dist Toggle to toggle between views. This field is shown only if the Default Processing View for this Payroll Group is set to Payroll ID.) This column shows the contents of the Payroll ID field for each base deposit record.

This field will show ”active” for items which will post, “suspnd” for any items which have been temporarily suspended and will not post, and “delete” for any items that will be deleted when the work file is posted. See “Command Keys” below for details on suspending or deleting a payroll item.

The system will multiply base deposits or distribution amounts by the factor entered in this column. The results of the multiplication show up immediately in the base deposit and distribution totals. NOTE: This change affects the current payroll only; the master file will not retain this multiplier.

• For example, you might use this field for payrolls for teachers that receive three month's pay in the June payroll. In this case, rather than adjusting the deposit amount for the June payroll and then having to change it back in September, you would enter “3” into this field when processing the June payroll. If the normal base deposit amount was $3,000, a single entry on the teacher's statement for $9,000 would be made.

(This field can be maintained for base deposits, and can also be maintained for distributions if the Allow Distribution Maintenance parameter in the Payroll Group record is set to Y.)

This amount is originally taken from the master payroll records. If a change is made to the Current Amount, when the payroll is posted the master records will be updated to reflect the change.

On distribution items (those that show an account number in the Dist Account field), changes to this amount can be made only if the Allow Distribution Maintenance parameter for the Payroll Group allows it. If necessary, use F6-Maintenance to perform maintenance on the distribution amounts.

This field shows the total amount of funds being deposited into base deposit accounts only. Any amounts assigned to distribution accounts are not included in this total.

This field shows how much of the total payroll will be transferred from base deposit accounts into distribution accounts. This amount should not be higher than the Total Member Payroll amount.

Description

Use this to toggle between two displays: one showing all base deposits and distributions, the other showing only base deposits, sorted in order as indicated by the Default Processing View setting for this payroll group.

Use this to permanently remove an item from the payroll list. The item will be erased not only from the work file, but when the payroll is posted, it will also be removed from the master payroll file. If a base deposit item is deleted, all corresponding distribution items will also be deleted. (When in doubt, try using F16-Suspend instead.)

Select the item to be deleted and use F4-Delete. (The screen may roll; use Roll keys if necessary to redisplay the list.) The Status column will now read “delete” for any item that was deleted.

• IMPORTANT: The deletion becomes permanent only when the payroll is posted. If items are deleted by mistake, use F3-Backup to return to the previous screen, then use F4-Delete to delete the entire work file. All changes made to the work file will be removed and a new file can be created using the original master records.

Once the payroll has been balanced, use this to save the changes and proceed to the final screen.

• The system will allow you to proceed even if the payroll is not in balance; the final screen will show the difference between the payroll check amount and the total of all distributions.

Use this to maintain base account and distribution information for a specific member.

Use this to display the Member Inquiry screens to look up account information for a member.

Use this to temporarily suspend a deposit from being made, without deleting the record permanently. Select the item in the list and use this button.. If you suspend base account data, the system also suspends any corresponding distribution data.

• This can be used to suspend an entire base record (along with all distributions) when an employee does not appear on a payroll list, but you do not know if that situation is temporary or permanent. It can also be used to suspend a single distribution when a member requests to temporarily stop contributions to a Christmas Club account, loan, etc. The account and distribution data remain in the file, but the associated transactions do not post. When you want the payroll distribution to resume, select the item and use F16 again.

Check out these additional video resources!