Simplify Your Billing with Our Invoice Reconciliation Template Excel for Production

Invoice reconciliation template excel for Production

in this video I'm going to demonstrate the mum fen process for reconciling your supplier statements or your vendor statements now there are two methods we can used aged accounts payable or we can use ledger entries I'm going to show you both in this video and you can pick which method you want to use so to start we're we're going to used aged accounts payable so to access this you click the search button in the top right hand corner and search for aged accounts payable once here you need there are a few options you need to fill in you can age it by a due date or posting day I tend to leave this as due date and then just set the aged off as the end of the month and depending on how you want this set up just play with these options till you get it comfortable the period length would be one month this you need to tick this print details of wise you're just going to get the total balance and then I like to take the new page per vendor and what we're not going to do is preview or print this we're going to send it straight to excel so you need to select send to excel document and we'll just open this file and you'll see what we get so this is the excel document that you'll see just shrink it down sighs so you've got all the supplies along the bottom here so it's actually put each supplier on a separate tab and you can see the posting date the due date and then you'll have the aged band so you can see what's due at the end of which particular month and you can use this to print this off and you can just reconcile it you can use the printout to reconcile it or you can actually do it in Excel if you get any long vent external document numbers if you just simply just drag this out it will drop it back down to one line then if you want to print this off if you select print you want to use the scaling fit sheet fit all columns on one page and then it doesn't matter how wide the document is it's going to fit on one page for you ready to print out so that's how you use the Aged accounts payable the second method is to use the ledger entries so to use the ledger entries you to go purchasing vendors you need to find the vendor that you want to reconcile in this case we use this one as an example select process ledger entries now you're going to be presented with lots of columns here now this is down to you to disable enable the disable and enable the columns that you want to see on this report so to do this you right click on one of these headers and select choose columns then you can simply just disable and enable the columns that you want to export to excel now the first time you customize the columns you have to close this window and then reopen the window otherwise the export to excel won't work so what I can do from here I can there's a button at the top called open in Excel and this is going to produce a download in Excel for me so this is now what I have from Excel and then what I can do from here is start customer to start filtering the due date so if I only want to see the documents that are due in October for example I can do and then I can print this off so very flexible both ways work the ledger entries give you a more detailed view where the aged accounts payable is just good for a quick reconciliation so I hope that helps got any questions please let me know thank you