Mitchell Metals

All invoicing will come through the email with a CBI Form and a Summary spreadsheet. These items will give you the parent and the child information, all invoices are booked under the child.

1. Go to Company (P:) - Job Files (Material Only) - job name - contract documents - quote & worksheet - excel summary sheet
   1. Make sure you have the most current one by matching the title of the one sent in the email.
2. On the spreadsheet below the yellow highlighted box titled "Accounting Only," put the CBI date, 50% deposit, and @roundup(cell w/ total,0)/2
   1. This formula will give the exact deposit amount to be billed
3. In QB, go to customers and search for the child (job name) and create a new invoice
4. Change the class to "Materials Only," change date to match CBI Form, change tems to "Due upon receipt," change ship via to "N/A," customer message should say "We appreciate your prompt payment," and copy and paste the job name on the memo line
5. Item code is "Deposit for Material Only"
   1. This is a subtotal group and you only enter the total amount due on client deposit line
6. Email the invoice to the customer, cc accounting and the pm
7. Save a copy of the invoice in the job file under "Pay Apps-Invoicing"
8. File the emails under "Materials - Completed

1. In QB, go to customers and search for the child (job name) and create a new invoice
2. Change the class to "Materials Only," change date to match CBI Form, change terms to "Net 30," change ship via to "N/A," customer message should say "We appreciate your prompt payment," and copy and paste the job name on the memo line
3. First item code is "Materials"
   1. This is a subtotal group and you enter all the material listed on the pull sheet in ERP
   2. Enter amounts for each item line as listed in yellow accounting box on job worksheet
4. Next item code is for sales tax if applicable (ie GA - Cobb) this line totals automatically
5. Next item code is "Labor" if applicable.
   1. For material only, change the total labor line description to "Welding labor performed at factory"
6. Last item codes are for Engineering, Delivery, and whatever else is listed in the yellow accounting box on worksheet
7. Email the invoice to the customer, cc accounting and the pm
8. Save a copy of the invoice in the job file under "Pay Apps-Invoicing"
9. File the emails under "Materials - Completed

1. In QB, go to customers and search for the child (job name) and create a new invoice
2. Change the class to "Install," change date to match CBI Form, change terms to match retainage rate on CBI, change ship via to "N/A," customer message should say "We appreciate your prompt payment," and copy and paste the job name on the memo line
   1. Add an "E" after the invoice number
3. Item code is "Engineering Subtotal"
   1. This is a subtotal group and you enter the Engineering amount from worksheet on the "reimbursement for engineering line" and the rest of the amount billed on "deposit for engineering" line
   2. Add job name to the deposit line in group
4. Be sure to take out retainage if applicable
5. Print for Tracy to file

1. In QB, go to customers and search for the child (job name) and create a new invoice
2. Change the class to "Install," change date to match CBI Form, change terms to match retainage rate on CBI," change ship via to "N/A," customer message should say "We appreciate your prompt payment," and copy and paste the job name on the memo line
3. First item code is "Materials"
   1. This is a subtotal group and you enter all the material listed on the pull sheet in ERP
   2. Enter amounts for each item line as listed in yellow accounting box on job worksheet
4. Next item code is for sales tax if applicable (ie GA - Cobb) this line totals automatically
5. Next item code is "Labor"
   
   1. Enter amounts for each item line as listed in yellow accounting box on job worksheet
6. Last item codes are from the "Additional Charges" box in the accounting area of the worksheet (ie Blockout Shipping, Lifts, etc)
7. Print invoice for Tracy to file
8. If billing for retainage, create another invoice following steps above and the only item code is "Retainage"
   
   1. Add an "R" after the invoice number
9. Print this invoice as well
10. Mark job closed with the current month in QB

1. Check Email for raises - make those changes
   1. Employee Management -> Employee Pay -> Salary
   2. Always "+ Add New" - don't edit an old raise
2. Check Email for Simple IRA changes, insurance changes, etc.
   1. Employee Management -> Employee Pay -> Deductions
   2. Find the correct deduction and edit
3. For Garnishments - send the paperwork to the PayPro and they will set those up
4. Check Email for Employee Installs
   1. Make a list of who did the install, the job and how much they should be paid
5. Check Email for any vacation and/or sick days that need to be entered into vacation system
   1. Employee Self Service -> Time -> Employee Absences
   2. Find Employee
   3. Go to "+ Add New"
   4. Entere Absence Date, Choose Sick or Vacation, Hours, Start Time, Enter reason in comments
6. Check to see if this is a bonus payroll - see calendar below

1. Look closely at all time cards and make sure they are correct
   1. Mike will check all of the warehouse timecards and bring over the signed timecards to you
   2. Clean up any intern entries (sometimes a lunch is added that needs to be removed)
2. Lock the time cards
   1. Payroll Processing -> Close Pay Period
   2. Lock Timecards
   3. Commit Timecards
3. Add extra pay for Installs
   1. Payroll Processing -> Payroll Entry -> Individual Time Entry
   2. Find Employee
   3. Will need to "+Add New"
   4. Choose a check without Deductions - Save
   5. In new check go to the Template called "All" on right hand side
   6. Find the "Other Earnings" line and enter the toatl amount o be paid to the employee
4. Bonus Payroll
   1. Payroll Processing -> Payroll Entry -> Time Entry Grid
   2. Enter the bonuses in the bonus column
5. Once all the changes, bonuses, extra pay has been entered, preview the payroll
   1. Payroll Processing -> Close Pay Period
   2. Preview Payroll
6. Run 2 Reports
   1. Payroll Register
   2. Payroll Summary
7. Copy the previous payroll JE calc into a new spreadsheet
   1. Enter the data from the Payroll Register and Payroll Summary
   2. Makre sure everything balances
   3. Enter your JE in QuickBooks
8. Approve the Payroll
   1. Payroll Processing -> Close Pay Period
   2. Process Payroll
9. Save the Payroll Register and the Payroll Summary on the Accounting Drive
10. On the 1st payroll of every month, add $12k for Jeff's Distribution

 After each Payroll: 
  
 Use the Payroll Register Report from the payroll reporting 
  
1 Go to the appropriate year tab in this workbook 
2 Enter the check date of the payroll from the Payroll Register 
3 Look for each employee in the Payroll Register and enter their IRA contribution in to the worksheet 
  
 At the beginning of each month: 
  
1 Total all contributions from the previous month 
2 Run the memorized report in QB -- Memorized Reports -> Accountant -> American Funds Contribuition by Employee 
3 Make sure the total in this spreadsheet matches the total in QB 
4 Save a PDF version of this report on the Server in the American Funds folder 
  
4 Log into the American Funds website 
5 Select an Action from the Salary Deferral-Simple IRA dropdown -- Select Submit a Roster 
6 Enter the total contribution by employee for the month from this workbook 
7 Make sure the total ties to the total on the QB and  the totals in this SS 
8 Submit the Roster 
9 Confirm the transaction and save a PDF of the confirmation in the American Funds Folder 
  
10 Got back into QuickBooks 
11 Pull up the American Funds vendor 
12 Copy the check from the month before 
13 Update the amounts by employee and save the transaction. 
  
  
 January Match 
1 Copy the calucator in the monthly spreadsheet 
2 Enter each employee's total compensation for the year 
3 Total all of their Simple IRA contributions for the year 
4 Calculate the Employer match. 
5 Log into the American Funds websit 
6 Select an action from the Employer Contribution - Simple IRA -- Select Submit a Roster 
7 Follow the same steps as above except label the entries as employer match. 

When a new employee starts at Mitchell Metals, Tracy will meet with the employee first to get them to fill out their I-9, G-4, F-4, employment application and emergency contact form.

Tracy will also take set them up so they can use the biometric time clock (if needed) and she will do the initial setup on Paypro.

When you arrive at the office, Tracy will have the new employee's file ready for you.  Tracy will also take care of the E-Verify.

You will need to login to Paypro (iSolved) 

• Go to the Employee Management Tab
• Go to Employee Maintenance
• And start with the Tab called General

Find the name of your employee on the Employee list and work your way down the menu.

Sales Tax Liability Report

• Vendors Tab --> Sales Tax --> Sales Tax Liability
• Report is set up to run as CASH basis and should always bring up the data from the previous month.
• Load the report into a new Excel workbook
• Save the workbook in the Sales tax File as "month.year Sales Tax Liability"
• This will be where you leave notes as you file sales tax for each state.  Leave this file open. 

Check every state.  

• Highlight every county that has sales tax inside each state.
• Highlight the total line for each state an make sure the Taxable sales for the counties is same or lower that than the Total Taxable Sales.  The total for the counties can be lower because some counties do not charge sales tax.
• It is fine to leave out the tax exempt sales.  We are liable for the sales tax for the taxable items but many states want to record thy non-taxable sales as well.  We do not have to report non-taxable sales to the penny, Do not spend a lot of time trying to calculate that number.  Just make sure the taxable sales number is correct.

Alabama 

This is one of the most complicated states because we pay state tax, county tax, and city tax.

This means that two returns will be filed -- a state return and a county / city return.  These return are located on the home page when you log into the website.

NOTE:  If you need to file a zero return, you file only the state return as zero.  You do not need to file a city/county return.

State sales tax:

• Log into the Alabama Department of Revenue website.
• To pay the State tax only, you will choose the "Sellers Use Tax"
• Find the correct period and click on file return.

When everything has been entered into to the return.  Push NEXT.

Save the confirmation as (last day of month) Alabama State Tax Pay Conf

County and City Tax

This a a mess.  Alabama has different sales tax numbers for a small number of their counties and cites.  To get the sales tax numbers, you will need to apply with them. Work with Tracy to get that done.  Once you have gotten the new numbers, will need to save those certificates and emails on the server.  

Here is where all of the licenses are on the server:

P:Shared Company FilesFormsGeneral Office ManagementBusiness License

All of the licenses are located here along with the emails and information from the cities and counties.  Use the numbers provided when filing taxes in these counties / cities.  

If you do not have a number, use the state number for filing.

Choose the correct filing month on the next screen.

Choose file or view a return on the next screen

The gross amounts for the cities and the counties are on the Sales Tax Liability Spreadsheet.

The Locality Name is based upon what county or city has sales tax in your spreadsheet.
You will need to look them on on zip to tax to figure out how the county and city work together.

In this table, you will need to fill out the following:
Tax Type = Sales Tax
Rate Type = General
City/County Tax Acct #: Look up on P:Shared Company FilesFormsGeneral Office ManagementBusiness License to see if they have a their own license number.
If not use LCL-R008315599, which is the Mitchell Metals Local tax filing number.
Gross Amount = enter the Taxable Sales number from the spreadsheet

Click OK. You will get a message about adding other counties or cities. If you used, zip to tax to check everything you should know exactly what needs to be filed.

Once the Return table is valid. click Next

On the next screen, save the return as:

(last day of month) Alabama Local Tax Ret

Save the payment confirmation as:

(last day of month) Alabama Local Tax Pay Conf

Click on the Adjust button.

Login into the FL website.  Top login that requires the User ID and Password.

Look for any important messages on the Bulletin Board page and Press Next.

Select Tax Website - Choose Sales and Use Tax

Choose Activity - File and Pay - Choose DR-15EZ (Sales and Use Return)

The State of Florida is one of our easiest returns because we do not have to file by county. We pay the tax directly to the state.

Enter you name on the signature line along with your phone number and the accounting email.

Enter the Gross Sales, Exempt Sales and Taxable sales.  (the math should be correct)  

Enter total tax due.

Click Next.

One last check, and choose Enter Payment.

NOTE:  If this was a zero return, at this point you could choose Submit Return only. Save copies of the Zero return and you are done.

Debit Date:  Change the date to the 19th.  Cannot send the debit on the 20th because it will be considered late.

DO NOT check the box for the banking information on file.  Use the Bank Routing Number and the Bank Account Number that is saved under the Florida login on the apngroup.org page.

Sign the return, enter your phone number and the accounting email.

Choose Next.

Check over everything one more time.  Click on Submit.

Save the return and the payment confirmation as:

(last day of month) Florida Sales Tax Ret and Pay Conf

Go into QuickBooks and enter the payment.

Login into the GA Website.

Chose under Accounts - Sales and Use Tax

Look for the correct month and choose File Return.

To determine the form --- See Answers to the questions below:

Using the Sales Tax Liability Report enter the following numbers from the GEORGIA STATE line.

The math should match the Taxable Sales on the Sales Tax Liability Report.

Enter the total tax collected and choose Next.

Look at the state tax calculation.  Make sure it is close to what QuickBooks calculated.

Overwrite the counties that were used int he previous return and enter the sales for each county.

Clean up the return if extra counties are left or add rows if more are needed.

Check the sales tax calculation as you entry.  This is where you will catch tax rate changes to the items in QuickBooks.  Make notes on the liability report as you go so you can make those changes once you are done.,

When all of the counties are entered, look at the total tax calculation.  Make sure it is close to what you would expect it to be.

Once you are happy with the return.  Click Next.

Total amount due should be the calculated Sales/Use Tax - Vendors Comp.

This return has the yearly prepaid calculation which is making the amount due much lower.  Book a journal entry to change the prepaid amount on the balance sheet.

Make notes on the sales tax liability report and choose submit.

Click on Print Return and save as:

(last day of month) Georgia Sales Tax Ret

Click on Print Confirmation and save as:

(last day of month) Georgia Sales Tax Conf

Click on Make a Payment

Change the Payment Date to the 20th

Confirm the amount 

Choose Submit

Save the Payment Confirmation to the server as:

(last day of month) Georgia Sales Tax Pay Conf

Book the payment in QuickBooks

Kentucky has a strange login.

Click on Begin your Registration.

Login is in the top right corner.

Once logged in click on MITCHELL METALS LLC

On the next page, it will likely tell you there are two filings due.  Click on File Taxes

Choose the account number 000309481

Find the correct return date and click on File Now.  If there is a second return there, it is likely for the next period. 

When entering the Total Receipts, do not include cents.

If you do need to report any Deductions, choose "Sales for which resale certificates received (Revenue form 51A105)" as the reason and enter the amount.

Check to make sure the amount calculated is close to the amount on the Sales Tax Liability Worksheet.  

Submit and sign the return.

View and Print the return and save it under this name:

(last day of month) Kentucky Sales Tax Ret

This will take you back to the Dashboard.

Click on MITCHELL METALS LLC

Then, on the next page, it will likely tell you there are two filings due.  Click on File Taxes

Choose the account number 000309481

Find the correct return date and click on File Now.

Click on the tab called Filing History and find your return that is "In Process"

Make sure the following fields have been filled out:

Click on "In Process" and then click on "Original".  This will take you the payment screen.

Click on Make a Payment.

Change the name to your name and click Next

Verify the tax account and choose the payment type -- ACH/Electronic check. See Below.

Submit the payment and save the payment confirmation as:

(last day of month) Kentucky Sales Tax Pay Conf

Nothing is saved to the website so all of the contact information has be entered each month.

See below:

This is where it gets complicated.

Enter the Gross Receipts and the Receipts exempt from sales tax.

Enter the Total Taxable sales in line 4 - Gen. State rate.

The County Rates are tricky:

2.0% = 2% County Rate

2.25% = 2.25% County Rate 

2.5% = 2% County Rate + .5% Transit County Rate

2.75% = 2.25% County Rate + .5% Transit County Rate

The .25% Transit County rate does not apply.

Put together your calculations prior to hitting next because you will be entering the tax only (not sales on the next part of the return) -- See Below

It will ask you to re-enter the Bank Account number and hit NEXT.

Save both Returns e-500 (state) and e-536 (county).  Save as: 

(last day of month) North Carolina State Sales Tax Ret

(last day of month) North Carolina County Sales Tax Ret

Save the payment Confirmation:

(last day of month) North Carolina Sales Tax Return Pay Conf

Login into the Oklahoma Website

Choose Vendor Use Tax.

If a payment is needs to be made....Most of the time this is a zero return.

The payment screen look a lot like the State of Georgia Payment screens.  Follow those instructions.

Save the return and payment as:

(last day of month) Oklahoma State Sales Tax Ret

(last day of month) Oklahoma State Sales Tax Pay Conf

If it is a zero return, you can insert the word zero into the file name so it is easy to find.

Log into the South Carolina Sales tax website.

Click on MyDorway

Login

Click on Sales and Use Tax

Find the correct month and click on the date.

Answers to Questions:

Check the box if it is a zero return.

Otherwise, enter the Gross Proceeds. 

To enter an exempt sale balance in the Out state purchases, you will use the View/Edit State Deductions -- choose Tax Exempt as reason an enter the amount there.

If everything calculates correctly, click Next.

You have to list all of the counties including the counties that have zero percentage of tax.  

See the table below.

Print the Confirmation and Summary Report.  Save as:

(last day of month) South Carolina State Sales Tax Conf

(last day of month) South Carolina State Sales Tax Ret -- print summary report

Click Pay

Authorize the payment and save the payment confirmation as:

(last day of month) South Carolina State Sales Tax Pay Conf

Log into the Tennessee Sales Tax Website

Choose to file the Sales and Use Tax

Find the correct date and click on File Return

Answers to the question:

Will you be submitting a file provided by your software vendor?  NO   Click Next

Next screen confirms the location -- Click on the Location ID 0105298653

Do you have any sales to report for this period? YES / NO Choose one (if NO, click ok and it will prepare the zero return)

If yes, more questions:

Are you ready to report sales based on delivery destination? YES

This takes you into the return.

Do not enter cents.

If you have exemptions, it asks for more info.  See below:

Next you will have to click on the blue box to report Local tax. 

Last question:

Do you have any single article sales, aviation fuel sales, or special rates on energy, water, vending, or specified digital products to report?  NO

Check the calculation on the return to make sure it is close to the QuickBooks calculation and click OK.

If you owe the tax choose the ACH option.  Update the Period.  Change the date of the payment to the 20th of the month.  Enter the amount twice.

Once paid, save the return and the confirmation as:

(last day of month) Tennessee State Sales Tax Ret and Pay Conf

Log into the tax website.  See below.

Click on File/Pay Use Tax from the Menu

Choose the correct filing period from the list.  Click on File Now.

If there were no sales click on the box beside "There were no sales made during this reporting period".  Click Create Return and you are done.  Just need to save the return.

If there are sales, click on all of the localities listed with sales on the liability report.

See below.  Enter the sales for the Localities:

Print the return and the confirmation -- Save as:

(last day of month) Virginia State Sales Tax Ret and Pay Conf

Enter the payments in Quick Books

Go to Vendors --> Sales Tax --> Pay Sales Tax

Make sure you understand how each state is paid.  For example, AL (below) is paid with two bank transfers.  One transfer goes to the state and the other goes to the cities / counties.

Once you have determined how the state is paid you have to pick all of the entries that go with that payment.  For example, we are paying the state of Alabama below,  We just need to pick the entry for the state.  We will pay the cities and counties in a separate transaction.

Change the obvious fields.

Check Date should be the 20th of the month.  

Check number should be debit.

Your entries should be checked and they will total in the Amt Paid column highlighted on the right so you can determine if you need to make an adjustment.  In this case we do so we are going to push the Adjust button.

Make all of the necessary changes again.

Change the date to the 20th. 

Entry No. should say Sales Tax. 

Update adjustment account to Other Income.

Determine what the adjustment is and enter the amount.

Click OK.

Check all of the obvious fields -- date, check number.

Make sure our entry and your adjustment equal the amount owed to the state.

If it does press OK and QuickBooks with register the payment and a journal for the adjustment.

Do this with every state.  I usually pay every state as I work through the returns to save time.

1. run the P&L for the month
2. create a transaction detail report from the Total Income 
3. Total By Customer
4. Gut check - Quickly look through each invoice to make sure inventory has been booked against it where applicable.
   1. on Quote Sheet the Bonnell number should be inventory on Candace's invoice.  If you see an invoice with a Bonnell number but no inventory ask her if she received a pull sheet.  Or pull up ERP to see if there are pull sheets and then have her update.  
5. Export to Excel
6. Sort by Name (Column H).  Clean up delete balance column, prepare for Pivot Table
7. Insert Pivot Table
   1. Name and Amount (sometimes add in Class)
   2. make sure same number matches total revenue in QB
8. Go to ERP
   1. Billing
   2. Select Dates Button
   3. Last Month
   4. Enter Totals on Pivot Table and Compare
      1. Material only could cause a difference because the 50% is on balance sheet still or we are finally billing the 50% once completed.
   5. Dig into differences and enter explanations

Open a new sheet in Excel.

Rerun the reporting in QB but sort by Name and do not total by customer.  Clean up the spreadsheet so it can bee used for a pivot table

In a separate sheet setup the pivot table.  Sum by name and amount.

****Quote Sheets:  Company P: drive, Job Files and Job Files (Material Only), Find Customer

- Contract Documents: Quote and Worksheet, Most Recently Saved Quote Sheet

Run a Balance Sheet as of the prior month (if working on Jan financials, pull December)

Look at non-inventory 

enter the beginning balance ( Blue) on the non inv stock allocation tab of financial statements

Run P&L for the month you are currently working on by class (if working on Jan finacials pull Jan)

look at total income - sort by class and total by class

enter install sales and Material sales (yellow)

Column C is your journal entry

look at non-inventory cogs and find the previous journal entry

create copy and update with the non inv stock allocation numbers

Since they moved to cash basis. This is probably no longer needed.

Talk with Tracy about watching out for these big expenses and start booking them as a regular expense

Run P&L from beginning of review month through the current day.

pull up the Gross Profit detail.

customize and add in debit and credit columns

Sort by name

Total by customer

Drop into Excel workbook, save Gross Profit by Job

Debit = expenses, credit = income

Look at each job 

• inventory (WL's) total kind of matches Bonnell Customer Sales Revenue.  Highlight to alert you've checked
• was non-inventory and freight charged for?
• Reimbursement for Engineering Fees - won't have expense associated with it in same month
• are dates all in same month?
• installers are contractors or Junior/Sebastian make sure match revenue, payroll entry may fall in another month.  Should we move expense to current month?
• welding is separated out on revenue but you won't see an expense match it
• Profit Margin is usually around 50% on projects.  Bigger jobs have smaller margin
• If you see expenses but no revenue, go see in ERP notes to see if the expense should be in another month.  Change date but DO NOT CHANGE DUE DATE.
• Field Measure we won't have an expense
• Blockout Shipping Okay to leave and have no invoice
• If expenses are more than revenue, check CBI form in ERP to see if done billing.  If not, check to see if any expenses be moved to next month.  Follow Up wtih PM.  
  • inventory may need to be on two pull sheets so inventory matches revenue.  

If engineering fees and no invoice, leave it alone.

Invoices - look all of the entries and make sure the correct dates are on the expenses.  All expenses need to be associated with the invoice.  When changing the date make sure you do not change the due date.

Make list for Tracy for items that have dates in the current month that have not billed.

Check to make sure they have not billed in prior months.  The expense could be old.

Run p&L year to date and total by month - have a few months to compare

look for trends, margins, etc. 

clean up suspense

Warehouse expense miscellaneous - make sure it was not a COG

look at salaries, look for swings from month to month

look for missing expenses

APN bill needs to be moved most of the time.

look for repairs that can be capitalized

Taxes other - fine to put business licenses there but income taxes need to be moved to distribuu

Balance Sheet Review

Look at client deposit accounts - Candace should keep an eye out.  Look for in and outs quarterly

make sure the bonus account is cleaned up - same thing about ins and outs.

simple ira is cleaned up - matching for the year, Paulette to move

look at total revenue - find the bonus tier

calculate gross profit percent take total gross profit / total Income

find the correct tier and make put in the correct month.

Find last journal entry, copy and accrue for this month expense dated EOM (paid in next month)

***if new employee, not eligible until 90 days.  On the first day of following month they are eligible.  If start 1/15/20 then 90 days is 4/15/20, eligible for bonus on May 1st so May Revenue. First bonus in first payroll in June.  

do not forget to add int the gross profit line in the P&L. - ***ADD IN GROSS MARGIN PERCENTAGE

Likes to see the current AR aging - as of that day, not end of month

1. Ask Mike when to complete the inventory adjustment.  He may want to do it earlier or a few days after the Quarter close depending on what is going on.
2. You will find his inventory count on the Mitchell Metals Computer.  Company P: ->Production and Shop Operations -> Inventory -> Inventory LIsts
3. The file you want will have "Count" in the name.  *** If file in protected, password is Brooks30
4. Save the file in Inventory Adjustment Folder on Accounting A:
5. Hide Column F (Building) through Total Lineal Feet
6. Add Columns:  Adjustments plus Qty, QuickBooks, Difference
7. Add a column for each Job in Production (Mike will proivde this, along with pullsheets for each)
8. Create a formula in the Adjustments plus Qty column that adds Qty (Column E) plus sum of quantities of Job in Production.
9. Do this for each tab:  Posts & Tubes, Beams, Caps & Pans, Gutter-Fascia, Misc, etc

**** when looking at MISC inventory items, ERP is shown in feet. To convert to inches here is the calculation: (ERP Qty * ERP Length in inches)/12 inches/Length Piece Comes in per Worksheet/QB

1. Make sure you are in Single User Mode
2. Go to Vendors -> Inventory Activities -> Adjust Quantity/Value on Hand
3. Change Adjustment Date to Date of Inventory Count
4. Click on "Find & Select Items..."
5. Type "Post" in the "FIND" box and hit SEARCH.  This will bring up all the Posts and Tubes.  Post would be replaced with Beam, Caps, Pan, Gutter, etc. depending on which tab you are working on from the inventory count workpaper.
6.  Click on "Clear All"
7. Delete the word "Post" from the Find box and enter in finish and color.  For example "BE MB" for Post Baked Enamel Medium Bronze.  
8. Click "Add Selected Items"
9. Update the New Qty column in QB with the Adjustment plus Qty number from the workpaper for each Item.  
10. Enter in the Original QB Qty on Hand to Spreadsheet so it can calculate the difference
11. Do this for each item
12. In QB, in the Memo filed, enter "Posts and Tubes BE MB"
13. Hit Save.  This will create a journal entry in QB that hits Account #5090 Physical Count and Scrap Adjustment"
14. Repeat for each Type of Inventory, Finish and Color.

1. Export Account Detail for #5090 Physcial Count & Scrap Adj
2. Summarize by Color and Part 
3. Send to Jeff with Explanations of Differences
   1. Missing Pull Sheets
   2. Double Pull Sheets
   3. Phase Jobs

1. Go to Report Writer
2. Jeff's Reprt
3. Preview by Company Tab
4. Enter hire date through 1 year
5. PDF Generate Report