Month End Reports Using ERRM

Accounting / File / Month End Reports

AR Reports: This report will balance to the AR standard account code. This report is updated when an order is either billed or job costed and no money has been posted to the order. The order then comes off the report when the order has been paid in full.

AP Reports: This report will balance to the AP standard account code. This report is updated when an AP invoice is posted. The invoice then comes off the report when the invoice has been paid in full.

Accrued Inventory: This report will balance to the Accrued Inventory standard account code. This report is updated when material is received from a bill of lading. The material then comes off of the report when the

material is costed.

Accrued Labor: This report will balance to the Accrued Labor standard account code. This report is updated when a provider record is posted. The record comes off the report when the provider record has a

date paid. (The user must run print and post providers.) NOTE: The accrued labor account in the journal gets debited at the time of doing payroll; therefore there may be a slight timing difference between the balance of this report and the balance in the journal.

Un-Billed AR: This report will balance to the A/R Unbilled standard account code. This report is updated when an order is billed. The invoice comes off the report when the order is booked or job costed.

WIP Material: This report will balance to the WIP Material standard account code. This report is updated when a delivery ticket is printed and lines are now in a delivered status. The figures drop off this report when the order is booked or job costed.

WIP Labor: This report will balance to the WIP Labor standard account code. This report is updated when a provider record is posted. The record will come off the repot when the order is booked or job costed.

Month End Inventory Balance Report: This report is designed to balance with the Inventory standard account code. This report gets updated with the following:

• Roll inventory value is as of date received. Value = Cost X available amount (Available amount = Amount available + Amount reserved)
• Item inventory value is as of date received. Value = Cost X available amount (Available amount = Amount available + Amount reserved)
• Cut & Delivered from lines as of cut date on the lines (Pre-ERRM records)
• Roll Inventory Value Uncosted no invoice date on or before date entered. Value = Cost x quantity received.
• Item Inventory Value Uncosted no invoice date on or before date entered. Value = Cost x quantity received.
• Percent Partial Billed Material (Pre-ERRM records)

Booked not Jobcosted: This report has been added to track booked orders which have not been Job costed to see which orders are ready to job cost based on all inventory being costed. This report will only show if ERRM has been activated.