Time Entry billing system
This is for users who use the time entry system to input time by job, then bill the time to customers, and outsource their payroll information.
Setup
- Set up Sub-Tables for customers (recommended 10) and jobs (recommended 30). General Ledger > Sub-Table Maintenance
- Select time entry system in General Ledger > Company Master Maintenance > Company Settings / Payroll Time Entry system type: Time Billing (time entry billing)
- Set up Chart of Accounts [F11]; tag the Sales and Cost of sales accounts to the job Sub-Table
- Set up the Time Entry Options tab in Payroll > Advance Options.
NOTE: You must set the following options:- Sub-Table for Job #
- A/P Journal
- Billing Journal
- Labor Cost Journal (payroll journal)
- Employee A/P acct for expense reimbursement
- Billing A/R acct
- Set up Customers in Sub-Account Maintenance [F12].
Note: When you set up customers, the A/R tab will allow you to set discount terms. - Set up Jobs in Sub-Account Maintenance [F12]
NOTE: When you set up each Job, the A/R tab will allow you to pick the customer code to bill the job. - Set up Pay detail codes in Payroll > Basic Options. See Pay Detail set up in Payroll.
- Set up Pay Codes in Time Entry. Time Entry > Pay Code Maintenance
- Set up employees under Employee master maintenance
NOTE: You only need to set up the following- Name/Addr Tab – enter name and SSN
- Earning/Deduction Tab – set up pay detail code for employee and default pay rate.
- Vacation/sick Tab – Default Pay Code for employee and Overhead Pct for the company
- Set up any third-party charges as an employee in Employee master maintenance. Mark the Pay type as P/T Hourly.
Cycle in Time Entry
- On the Date Maintenance screen, enter the date range to enter the employee's time and the date of your invoices. Time Entry > Date Maintenance
- Complete Time Entry for Week & Print Listing/Review > Time Entry > Time Entry
- Assign Invoice #'s to the billing - Time Entry > Assign Invoice#s
- Create A/P entries and extract the expense reimbursement part of the billing.
NOTE: Use this only if you want to write expense reimbursement checks out of A/P before updating the billing. Otherwise, the updated billing will create the extract and entries. Time Entry > Create A/P Entries - Print the Payroll Report to send to the outsourcing company. Time Entry > Payroll Report
- Mark any invoices that need to be held (i.e., not sent in this billing). Time Entry > Hold Invoice
- The Billing Edit lets you view the total billings before printing the invoice. Time Entry > Billing Edit
- Print the invoices to send to your customers. Time Entry > Invoice Print
- Backup Pak Accounting Files > Utilities Menu or your own company backup system
- Update the billing. Creates and puts the entries in Unposted Maintenance in the general ledger. Time Entry > Update Billing
- Post G/L Entries Because the entries are in Unposted Maintenance, they must be posted to record them in the General Ledger.