Check Invoice against PDF

Check Invoice against PDF

Invoices are imported automatically into PalletWatch from CHEP and Loscam.  Invoices can be viewed by going to Data and then Invoices.  Whilst invoices can be reconciled in this screen you can also reconcile by going to Actions on the main menu and then Reconcile Invoices.  This second option allows to you choose whether you reconcile all invoices at once or whether you select one specific invoice.

CHEP can provide daily import files which means that you can reconcile every day and thus have less to do when the weekly or monthly invoice is imported.  Daily CHEP import file numbers begin with the letter 'D'.  It is not essential to action these daily files as they will be cleared once the invoice is imported. It is however recommended that they be actioned progressively.   Loscam can only provide monthly files at this stage.

The fields on the Reconcile screen include:

Auto Matched

When the file is imported PalletWatch measures the percentage of imported transactions which match up with transactions that have been entered.  A measure greater than 90% is what should be aimed for.  The Auto Matched percentage figure is taken when the file is imported and does not change.

Unreconciled

This shows the number of transactions still to be reconciled.  Ideally this should be blank before you're next weekly or monthly invoice arrives.

Total

This is the total number of transactions imported.

Check

This is where you check PalletWatch summary invoice figures against the CHEP or Loscam PDF invoice.  If the Check box is red then the figures need to be checked, if the box is green then it indicates that the figures have been checked.

The checkboxes should be ticked if the figures agree with the PDF invoices.  If they do not agree submit a ticket to PalletWatch Support.

Reconcile

If a Reconcile button is displayed then that indicates that there are transactions to reconcile.  Clicking this button will display the unreconciled transactions or you can go to Actions and then Reconcile Invoices.

• Related Articles

• Downloading a PDF Invoice from Loscam Online

  Downloading a PDF Invoice from Loscam Online To check PalletWatch summary invoice numbers against Loscam numbers you need to have a copy of the Loscam PDF invoice.  It can be either sent to you by Loscam or you can download it from Loscam Online.  ...

• Unreconciled Invoice Report

  Unreconciled Invoice Report The Unreconciled Invoice Report can be found under Reports in the main menu and can be downloaded as a PDF or Excel.  This report can be very useful if you want to send a list of unreconciled transactions to one of your ...

• Unreconciled Invoice Docket

  Unreconciled Invoice Docket In Data/Dockets you may see a blue question mark icon. This indicates that there is an unreconciled movement in the Reoncile screen for this docket.

• Loscam Compensation

  Loscam Compensation When a compensation payment is made to Loscam they do not send the transaction in the invoice import file but it will appear on the Loscam PDF invoice. You will be able to identify that a compensation payment has been made if you ...

• Reconcile Report

  Reconcile Report The Reconcile Report is the most important report in PalletWatch as it lets you know if you have gained or lost equipment. The Reconcile Report can be run at any time and should be run at least monthly. The report can be run from the ...