 QuickBooks Desktop 2023. Accounts payable aging reports. Let's do it within two weeks, QuickBooks Desktop 2023. Support Accounting Instruction by clicking the link below, giving you a free month membership to all of the content on our website broken out by category further broken out by course. Each course then organized in a logical, reasonable fashion, making it much more easy to find what you need than can be done on a YouTube page. We also include added resources such as Excel practice problems, PDF files and more like QuickBooks backup files when applicable. So once again, click the link below for a free month membership to our website and all the content on it. Here we are in QuickBooks Desktop sample raw castle construction practice file provided by QuickBooks going through the setup process we do every time maximizing the home page to the gray area. Going to the view drop down noting we got the hide icon bar open windows checked off open windows open on the left hand side. Going to the reports drop down company and financial P&L profit and loss income state with range change 010124 to 123124 January to December 24 customize it fonts change 12. Okay. Yes. Okay. One more time on the reports drop down company and financial this time the big balance sheet changing the dates this time with the drop down to the fiscal year 2024 customize it with the fonts and numbers to change it to 12. Okay. Yes. Okay. That's the setup process we've been doing every time. Now we're going to be focusing in on a subsidiary report last time we looked at the accounts receivable this time we're looking at the accounts payable remembering that the balance sheet and the income statement or profit and loss are the major financial statement reports pretty much every other report giving us more detail on a line item or multiple line items of a balance sheet or income statement report this time we're looking at those giving us more detail on the accounts payable quick breakdown. What is the accounts payable how did it get there it represents us owing money to someone else a vendor with QuickBooks terminology if we go on to the home page to break that down a bit more. We talked about the vendor center the vendor section I should say which could be called the accounts payable cycle or the expenses cycle. For example, note that if you're on a cash basis possibly simply using bank feeds waiting till transfers clear the bank meaning electronic payments of bills clear the bank. You could then enter those into the system which would be using a check form the form that decreases the check in account. You would be on a cash based system you wouldn't have any accounts payable or you can enter the checks manually for example and then reconcile them to the bank entering the checks when you write them. Then again you wouldn't have any accounts payable if you're on an accrual basis method then you're entering the bills when you get the bills which are typically closer in the point in time that you actually have the work done for you. Vendors representing people that are going to be giving us goods and services and we're going to be paying them ultimately. This is the form that increases the accounts payable and then we pay them at a future point with a pay bill form which is in essence a check form but specially named a check form that's decreasing the bill decreasing the accounts payable. So that's the general concept larger companies typically are going to have more and more need for tracking the accounts payable and it's going to become more and more important from a cash management standpoint to try to pay the accounts payable as late as possible. So if we go back to the balance sheet then we can double click on this accounts payable right here and we can see that it's going up with bills the bill form and it's going down with the pay bill or the paycheck form we're paying with a check bill check here. That's the general scenario that we would have. Now if we had questions about a particular vendor balance or something like that we might not use the reports but rather simply go right into the vendor center which on the homepage you could do that going here or you can hit the drop down to the vendor center there. And this is useful because if I go to the first tab the vendor tab I can sort the vendors by having vendors with the open balances. This is in essence kind of like a report showing all the vendors that have the balances outstanding. I can go into that particular vendor if they have a question I can look at the outstanding bills for them and start to drill down on those questions. I can also go to a transactions detail report go to the bills here and I can sort by the open bills the outstanding bills the overdue bills. So this is where you will probably go for kind of like your subsidiary ledger rather than another report. That's why the aging report like with the receivables is probably the most common report that you'll be using outside of you know just the vendor center. To see those reports related to accounts payable let's hit the drop down you could find them here by going to the vendors. Here's your reports AP aging most common the detail the vendor balance summary the vendor balance detail unpaid bills account. You got the graph and the transaction list. Let's go into the actual center here though the report center and see them there going to maximize this once again because it unmaximizes every time you go into the report center for some reason. We're going into the vendor location down here and this is the most common one. That's why it's up top because but let's look at the one that's that's kind of like the general sub ledger of that being the vendor balance summary. If I go and run the vendor balance summary report then we've got a breakout of who we owe money to. And it's about by vendor by vendor the total adding up to twenty six six thirty six ninety two that should tie out to what's on the balance sheet twenty six six thirty six ninety two. Notice it's quite likely that those will tie out you can't really mess up the tying out of the balance sheet account of accounts payable to the sub ledgers as long as you have the dates correct. Because every time you enter a transaction into QuickBooks QuickBooks basically forces you if you're going to post something to accounts payable to enter a vendor. In other words home page that's clear when you enter a bill clearly because then you have to assign the vendor. But you can imagine other transactions where you're going to try to use the accounts payable account on the other side of the transaction or with a journal entry. Even if you make a journal entry and you were signing it to accounts payable you still would not generally be able to post it unless you put a name here that name representing a vendor forcing you to give that added detail so that QuickBooks can always kind of tie out your sub ledger accounts breaking out by vendor who you owe money to to what's on the balance sheet. So closing that back out. And so so that's that report. Now again this report's probably not used as much because you could find that same detail in the report center as we just took a look at. You don't get the total in the report center so sometimes it's nice to see that total but that's that's why it's not as popular as the accounts payable aging possibly in actual use. The other one is the detail report if I run the vendor balance detail report in the report center. Then we have a similar report but it's just going to give you the detail for each of the vendors that gives you the bill and the check the increases and the decreases we should be able to take and tie off. That's what should happen in accounts payable it goes up with a bill down with a check that pays off what was owed. The total once again should be at the twenty six six thirty six ninety two tying out to what's on the balance sheet that looks good. Now this report also is one not used as much because you could find most of this detail if I'm looking at a particular vendor. I'll probably use the vendor center to look up that vendor and look at the detail in that area but you've got this report as well closing that out. We've got the report center and so those are the two main kind of standard sub ledger reports that you would think of as a sub ledger from accounting terminology. This is the most popular report giving you more added detail the AP aging report opening it up then let's customize it make it a little bit larger on the font and spend a little bit more time here. This will be similar to the accounts receivable aging it's breaking out by vendors you got those totals again on the total vendor but like with the accounts receivable it's showing us how past do these amounts are giving that added amount of information. Now how does it know how past do things are because when we enter the bill if I go back to the home page and I open a bill let's go back to a prior bill. So as we entered this bill this is a generic kind of bill I can go back to this one. We've got the date that we entered the bill on and then we've got the bill due date down below now the bill due date might be like 30 days later the dates are a little kind of wacky because. QuickBooks has been updating their practice file periodically and so I might make it a little bit unusual because they might have updated this date not that but in any case. That that's going to be the ideas that might be 30 days into the future so we have to have the bill due date to know when the bill is due and if we go past that date then it's going to be overdue. Obviously from a cash outflow standpoint from a cash management standpoint on the outflows the payables when we're paying our vendors we would like to pay them as late as possible. Typically that's our general rule. If we can keep the the amount being the same meaning if we can pay them sooner and get some kind of discount we might take the discount right or we're going to if not we're going to pay him as late as possible without getting penalized. And we want to not be penalized on it and of course we also don't want to upset our vendor relationship so we don't want to lag the payment. If it's going to cause a problem in our relationship with our vendor that's the general rule. Now note that for smaller companies it might not be a big deal if you pay them today or 15 days later and you just have a few transactions. You might say well what does it matter I'm just going to pay the bills when they come due I'm just going to pay them with an electronic transfer and and just take care of it then I'm not going to sit and track the bill. And that might be completely appropriate for some companies as the companies get larger however and you have a whole lot of transactions holding on to the money a little bit sooner can increase your cash flow and the better cash flow that you have the more capacity you might have to be able to invest in property plants and equipment which could increase the the ability to generate revenue. So large the larger the company is the more likely tracking the accounts payable is going to be more important the more emphasis is going to be on trying to delay in general the amount of payment as late as possible while still paying as least as possible taking advantage of any kind of cash discounts that that you would have. And so that's where the aging report then comes in because now we can kind of track this information by current stuff stuff that's not past the due date yet. And then the stuff that's passed 1 to 30 past 31 to 60 past 61 to 90 past and and then over 90 obviously we can use this report to sort and try to help determine which bills we want to pay when. Now if I go to the at the home tab you can do a similar kind of comparison here when we go to the pay bills. There's a whole lot of bills you can sort the bills like past past due date and sort the due date here as we pay the bills and we can do some similar sorting here in the in the accounts payable center. Let's go there again we're going to go to the vendor center I should say in the vendor center. We can sort in here and we can sort by the by the active vendors the vendors with balances and we can also then go to the to the transactions and sort the bills by open bills and possibly the overdue bills. So this vendor center is probably the place that most people will spend their time for the normal kind of digging down and drilling down on this type of information and determining which bills should be paid. But the reports can be an added value as well. Okay so we're going to go back then to let's go back to the to the report center and look at a couple other reports. You got the detailed report. So if I go into the detailed report it's going to give you the current and the 30 to 30 or 1 to 30 31 to 60 and then give you the bills that are outstanding. Those bills being the things that increase the account payables that have not yet been paid off closing that out. Let's go back to here we'll talk about graphs later so they got some nice graphs. And then we've got the we talked about the vendor balance detail the vendor we talked about these two unpaid bill detail. This is a report that you would think would once again tie out to the accounts payable at the 26 6 36 92. And that should tie out to the balance sheet 26 6 36 92 because the bills are going to be the forms that are increasing the accounts payable. And if they're unpaid then then those are the ones that are outstanding. You can kind of create this report by looking at the vendor balance detail and then filtering possibly by the bills and not just showing the detail or the activity of the bills or something like that. Or maybe well it might have still have the paid and unpaid bills in any case it's showing you by vendor and then just giving you the bills. So I'm going to close this one back out. We're going to then go back into the vendor center and we've got the unpaid bills. We've got the transaction list by vendor. So this will give us a list of transactions taking place by vendor. And then we've got the 1099 summary report. Now this is kind of a vendor report but it's also kind of a required report for tax filing. So maybe we'll spend a little bit more detail on that in a in a future presentation. You've got the sales tax. So we'll talk more about sales tax in of itself sales tax you can think of as kind of like a vendor. You've got to pay the government for the sales tax and then you've got your lists down below. You've got the vendor phone list. These aren't really transaction reports. They're information reports the vendor contact information and so on and so forth down below.