How To Run an Accounts Receivable Aging Report in QuickBooks Online

hi this is tim yoder with fit small business today i'm going to teach you how to run an accounts receivable aging report in quickbooks online this tutorial is one of our 46 free quickbooks online tutorials that you can find by googling fit small business quickbooks online tutorials so let's get started from our dashboard in quickbooks online in order to run any report we go to our reports in our left menu bar we can find our accounts receivable aging report by scrolling down into the who owes who owes you section we want the accounts receivable aging summary so let's click on that okay so for paul's plumbing we can see that the basic report is already set up for us any accounts receivable that are not overdue would be listed in the first column accounts receivables that are overdue by 1 to 30 days in the second and so forth so we can set options for this by scrolling up if the report is long enough you'll have to scroll up to get to these options at the top so let's set our report date as the end of last month so perhaps paul's plumbing reviews their accounts receivables at the end of each month so let's do this for nine thirty twenty twenty one anytime you change your options you need to hit run report and here we go here's our accounts receivable as of september 30th okay so a few options we can set we can change the number of days per aging period 30 days is pretty standard in an ar aging summary but if you would like to do shorter periods you certainly can you can change the number of periods this is four we could change it to five if we wanted hit run report then that will show from 90 to 120 days and then 120 days and over so a little bit of customization really just personal preference what works for you okay let's talk about this aging method date this is a little bit tricky so when we have the aging method here set to report date it's going to show the accounts receivable that are outstanding as of september 30th that so not only so these were outstanding as of september 30th okay if we change this method to the current date it's going to show our accounts receivable as of september 30th that are still outstanding as of the current date so today is october 13th so this accounts receivables from adam saracino i've actually gone in here and i've entered that we've received this payment on october 11th so that it's no longer overdue okay so by changing the aging method to current and then running report that accounts receivable disappears okay so when we run the report for 930 as of the current date which is october 13th it's only going to show the accounts receivable outstanding as of september 30th that are still outstanding as of october 13th if we change the this aging method back to the report date it's going to show all the accounts receivable as of september 30th even if they've been paid prior to the current date so i'm going to run that report and there we go the adam saracino pops back up so which aging method you choose is going to depend on how you want to use your report if you're using the report to decide who to make phone calls to then you certainly want to add it you want to use the current method right because you don't want to call adam because adam's already paid okay he paid on october 11th after the september 30th so if we run it by the current date adam disappears we won't accidentally call him and ask him for payment when he's already paid us okay so a little bit confusing hopefully that helps clear things up okay other options you can set um you can go over here to customize so some just basic customization options how do you want your numbers formatted how do you want negative numbers to show up in rows and columns there's not much you can do you can hide the zero rows and columns which is what we have here in the aging section we've already talked about this this is just the same options we have above the report in our filter option you can filter them by filter by customer or location now obviously if you're going to filter by those things you need to keep track of those things for every transaction so location might be something that's pretty useful perhaps your location managers are the ones that should make phone calls for customers that owe money but in order to use this location filter you're going to have to be very good about entering a location for every transaction you enter in quickbooks now to do that you're going to have to have your company set up right if you google fit small business quickbooks online tutorials you'll see that we have a series of tutorials that teach you how to properly set up your company and one of those will cover setting up locations in classes and then finally the header just some really personal preference items that you can work with so using these custom customization options you can really make the report your own okay so once you have your report exactly like you like it you can distribute it several ways by clicking the envelope here you can email it as a pdf or you can click the printer to obviously print it to your local printer or you can export the report and if you export it you can either export it as an excel file which would then allow you to manipulate it further or you can export it as a pdf file and finally if you have the report exactly the way you want it and you know you're going to want it like this numerous times in the future you can go ahead and save the customization so that you don't have to come back in and customize it every time so to save the customization let's click save customization and let's call it our customized call it our custom ar aging summary and click save okay now let's go back to our dashboard next time we want to run an accounts receivable aging report we go to reports in our custom reports we now have a custom ar aging summary and there we go that's how you print an ar aging summary in quickbooks online i hope this was helpful again to view all 46 of our free quickbooks online tutorials google fit small business quickbooks online tutorials

This transcript was generated automatically from the video's captions and may contain errors.