Streamline Your Invoice Reconciliation Template Excel for Security

Invoice reconciliation template excel for Security

purchase control is powerful and easy to ous purchase management software reconciling an invoice to the original purchase order and purchase control is an easy process when an invoice arrives from the vendor you can reconcile it against the original purchase order completing the three-way match this process ensures all the details on the invoice match which you have ordered and also what has been delivered to you before processing the invoice there are a number of ways to reconcile an invoice in purchase control perhaps the most straightforward method is to use the received uninvoiced search page this shows a list of all the purchase orders that have items that have been marked as received but have not yet been reconciled to an invoice you can use the search functionality to narrow the results and run more specific reports this is useful when doing reporting from the system as the received uninvoiced total gives you an easily accessed acral figure using the search function ality you can quickly get these figures for a specific department or vendor for example to reconcile an invoice to a specific purchase order you can select the order from the list this takes you directly to the invoices tab for the individual purchase order here we'll display any invoices related to the order in a list and also the overall figures in relation to what has currently been invoiced for the order this tab is linked directly to the original purchase order and can be accessed directly when viewing the order by clicking the invoices tab by clicking the new invoice button we can create an invoice using the details of the line items from the original purchase order add the invoice number from the invoice you received from the vendor and the invoice date you can then select the items you want to reconcile against if you are partially reconciling just select the relevant line items and click the process button you can then add general ledger or nominal Ledger codes and tax trates for the individual line items you can then save the invoice into the system if the order has been over invoiced the system will flag this and not allow the invoice to be matched in the case where there is an acceptable reason for the over invoicing we can edit the purchase order to match the invoice going back through the approval process to do this before matching the invoice to the edited purchase order if there is no acceptable reason we can query the invoice with the vendor in the cases where the invoice matches the original purchase order you'll be able to save the invoice once it is saved it will then need to be authorized for payment by somebody with authority to authorize that once the invoice is authorized it will be marked against the purchase order and show in the invoices tab we have now completed the three-way match quickly and efficiently with a full record of all the actions carried out within that process purchase control makes it easy to streamline your purchasing process and ensure all invoice payments are correct