×

Reconciliation

 
Click the “Reconciliation” sub tab to bring up the reconciliation form.  There are 3 sizable window panes: ‘Receivers’, ‘Received Items’, and ‘Job Assignments For Received Items’.
 
Reconciliation
1

Receivers

1. Receivers
When you receive a shipment against a purchase order, ShopPAK automatically creates a distinct ‘Receiver’ record.  When reconciling a vendor invoice, you don’t change the original purchase order information.  Instead, you use the “Reconciliation” sub tab to record any variance between the anticipated vendor invoice and the actual vendor invoice.  This gives you a clear and accurate audit trail between the PO and the reconciled vendor invoice. For each distinct delivery you receive against a purchase order, ShopPAK generates a distinct ‘Receiver’ record.  Most of the columns in the ‘Receivers’ grid are read-only (blue font) and are populated either from the purchase order, the receiver, or from other cells in the ‘Reconciliation’ sub tab.  Enterable fields use black font.
 
Reconciled
Read only.  If reconciled there is a check.  If not reconciled, the checkbox is empty.
 
Date Received
Read only.  Date the shipment was received.
 
Received By
Read only.  Person that received the shipment.
 
Vendor Invoice Number
Required.  The vendor’s invoice number. 
 
Vendor Invoice Date
Date on the vendor invoice.
 
Date to Apply Expense
When you reconcile the vendor invoice by clicking the “Reconcile” button, if this cell is empty ShopPAK puts the current date into the cell.  If for some reason, you need to pre or post date when you want ShopPAK to recognize material expense associated with this shipment, override accordingly.
Due Date
Optional, but if you export AP Bills to your accounting package, you can include a due date.  ShopPAK automatically calculates due date if you’ve supplied a ProjectPAK ‘Number of Days Due’ on the purchase order’s Vendor record.
 
Vendor Invoice Tax Rate
Tax rate the vendor has used on their invoice.
 
Override Vendor Tax
When blank, you enter the tax rate and ShopPAK calculates total tax.  When checked, you enter the vendor tax amount (tax rate is disabled).
 
Vendor Invoice Total Tax
Read only, unless Override Vendor Tax is checked.  Total invoice tax amount for the Receiver.
 
Vendor Invoice Total Unit Price
Read only.  Total invoice amount minus any tax and freight charges.  Bubbles up from the ‘Received Items’ area.
 
Vendor Invoice Total Freight
Read only.  Total invoice freight amount from the ‘Received Items’ area.
 
Vendor Invoice Total This Receipt
Read only.  Total invoice amount from the ‘Received Items’ area.
 
PO Tax This Receipt
Read only.  Total PO tax based on PO tax and the items and quantities received.
 
PO Freight This Receipt
Read only.  Total PO freight based on PO freight and the items and quantities received.
 
PO Total This Receipt
Read only.  Total PO amount based on PO amount and the items and quantities received.
 
Notes
Receiver notes.  However, we’ve made this editable in case the person reconciling the vendor invoice wants to add a note.
 
Reconciled By
Read only.  Person that reconciled the vendor invoice.
 
Date Reconciled
Read only.  Date the vendor invoice was reconciled.
 
Date Exported
Read only.  Date the reconciled vendor invoice was exported to an accounting package.
 
Exported By
Read only.  Person that exported the reconciled vendor invoice to an accounting package.
 
Remit To
Read only.  Vendor that you’ll remit payment to.  Defaults to the purchase order vendor, however, you can override by clicking the “Remit To” button at the top of the window.
2

Received Items

2. Received Items
ShopPAK displays a row for each PO Item that has receipt activity.  In other words, if a PO Item was not included in the shipment (it was backordered), there won’t be a reference to that PO Item on the ‘Received Items’ area.  If there are discrepancies between the PO and the vendor invoice, the person reconciling the PO against the vendor invoice makes most of their changes to this grid.  However, if the PO Type is for ‘Job’ or ‘Reserved’, then the person reconciling the PO against the vendor invoice makes quantity changes in the ‘Job Assignments For Received Items’ grid located at the bottom of the form.
 
Type
Read only.  PO Item type (Job, Reserved, Stock, Other).
 
Inventory Code
Read only.  If the PO Item is an inventory item, the inventory code is displayed.
 
Description
Read only.  Description of the PO Item.
 
UOM
Read only.  PO Item unit of measure.
 
Quantity Ordered
Read only.  PO Item quantity ordered.
 
Quantity Received
Read only.  PO Item quantity that was received on the shipment.
 
Vendor Invoice Quantity
If the PO Item type is ‘Job’ or ‘Reserved’, ShopPAK protects this field.  Make invoice quantity adjustments in the ‘Job Assignments For Received Items’ grid located at the bottom of the form.
However, if the PO Item type is ‘Stock’ or ‘Other’, make any vendor invoice quantity adjustments here.  Initially filled with the PO Item quantity.
 
Vendor Invoice Unit Price
Invoice item unit price.  Pre-filled with the PO Item unit price.  Override if the invoice has a different unit price.
 
Vendor Invoice Freight Amount
Invoice item freight amount.  Pre-filled with the PO Item freight amount.  Override if the invoice has a different freight amount.
 
Vendor Invoice Freight Tax
Read only.  Total invoice freight tax amount.
 
PO Unit Price
Read only.  PO Item unit price.
 
PO Freight Amount
Read only.  PO Item freight amount.
 
Notes
PO Item notes.  We’ve made this editable in case the person reconciling the vendor invoice wants to add a PO Item level note.
3

Job Assignments for Received Items

3. Job Assignments for Received Items
ShopPAK displays a row for each job assignment allocated against the currently selected PO Item (located in the middle grid).  ‘Vendor Invoice Quantity’ is the only cell you can edit.  All other cells are read-only.  When reconciling a PO Item type of ‘Job’ or ‘Reserved’, the person reconciling the PO against the vendor invoice makes quantity changes to this grid so we know exactly which job assignment quantity needs to be altered for tracking and job costing purposes.
 
Job Id
Read only.  Job Id of the job assignment.
 
Job Description
Read only.  Job description of the job assignment.
 
Item Description
Read only.  Job Item description of the job assignment.
 
Work Order
Read only.  Work Order number of the job assignment..
 
Quantity Ordered
Read only.  Job assignment quantity ordered.
 
Quantity Received
Read only.  Job assignment quantity that was received on the shipment.
 
Vendor Invoice Quantity
If the PO Item type is ‘Job’ or ‘Reserved’, make any vendor invoice quantity adjustments here.  Initially filled with the Job assignment quantity.
 
Vendor Invoice Unit Price with Tax
Read only.  Vendor invoice unit price with pro-rated tax amount.  Pre-filled with the Job assignment’s unit price plus pro-rated tax amount.
 
Vendor Invoice Unit Tax
 Read only.  Vendor invoice line item unit tax amount.
 
Vendor Invoice Freight with Tax
Read only.  Vendor invoice line item freight plus tax amount.
 
Vendor Invoice Freight Tax
Read only.  Vendor invoice line item freight tax amount.
 
PO Unit Price with Tax
Read only.  Job assignment’s unit price plus tax amount.
 
PO Freight Amount
Read only.   Job assignment’s freight amount.