Print Creditor Age with airSlate SignNow

Print initial creditor

in this video I'm going to demonstrate how to print the four most commonly commonly requested accountancy reports so you need to be logged in to your accountancy roll center to do this and you can either access the reports from here but it's a really good habit to get into use to searching for the reports so the first report we're going to start with is a trial balance so you select the light bulb in the top right hand corner and you search for trial balance and ignore these at the top I want you to go down to reports and analysis and select trial balance you then get presented with a report table and you've got to end some detail in here so you can select the type of account but if you leave all of this blank and very simply enter the date filter you'll be able to decide a period between two dates or up to a date so to do a date range for example we could do o 101 19 and then dot dot o 201 19 and it would be the first of January to the second January if I do a date range of dot dot and then a date it'll be up to that date if I leave it blank it's just going to run the trial balance without any date filters so we'll just go ahead and click send - and I advise you select Excel and if we take a look at the Excel document you've now got your trial balance within Excel within the date range period that you you've decided to filter the date range to let's take a look at how to do a detailed trial balance so again we're going to use the lightbulb in the top right corner and we'll search for trial balance again and you'll see now we've got detail trial balance they've got a few extra options in here so you can have a new page per GL account you can exclude the accounts that have a balance only and have no transactions within the date range that you've selected in it you can include closing entries within the period reverse entries and print Corrections only what I advise that you do is only select the new page per GL account and exclude jail account to have a balance only again you have your date filter so you can do a date range or a date up to or a particular date you also can flick between income statement and balance sheet if you want to so if we if we go ahead and send to excel so the detail will actually give you the document numbers and the debits and credits and the balance as well and you see along the bottom have got all these sheets with the detail on so that's a detailed trial balance the next will be a aged debtors and aged creditors so again if we use the light bulb in the top right corner and search for aged you see aged accounts payable and aged accounts receivable or these function in exactly the same way so I'm only going to do one and we'll do the aged accounts payable wrong one one second you want to go to sorry you want to go down to this bottom section again so we want to select aged accounts payable and then you just need to be careful that you make sure that if you're doing this if you're doing this first sort of like a year-end task then you need to make sure that you've got posting date selected instead of due date because this report can be as much operational as it is just a financial report so it's important that you select posting date then you select the date that you want to view up to we'll just leave it as this for this exercise period length can be one month and we just go to send to excel and we have an aged Accounts Payable and then you have your balances as well so I hope that answers the most commonly requested questions on how to print certain reports so that was a trial balance detail trial balance debtors and creditors but it remembers Aged accounts payable and aged accounts receivable and make sure you set the date to posting date any questions please let me know