Summary
Join Brian Hatch as he reviews how to run the Household Trial Balance report in RecTrac. Also known as the Global Trial Balance report, Brian highlights various output types available and some key criteria options that may help you narrow down the data you are looking for.
Video
Transcript
00:00:05:11 - 00:00:25:16
Brian Hatch
In this video, we review the topic of the trial balance report and RecTrac also known as the Global Trial Balance report. On this report, it gives you the ability to pull all household balances in your database, and this includes credit balances along with debit balances and also net balances if you're looking for the difference between the two.
00:00:25:18 - 00:00:44:19
Brian Hatch
To access this report, you can go through your menu and just type in the word trial and you can also access it from your output listing or management as well. But also trial balance. I actually already have open here on the screen. So just like most reports, you have a DataGrid on the left hand side. In this case, it's a household DataGrid.
00:00:44:19 - 00:01:03:00
Brian Hatch
So if you only want to run it for certain accounts, you could do that on the left, on the right hand side, we have our household range. So if you're trying to run this for all households in a database, which is very typical, you just want to make sure that the use household number range is on and the blank through all nines is basically to all household settings.
00:01:03:00 - 00:01:26:05
Brian Hatch
So you can include that on the right hand side if that's what you're looking for. Above that, we have a household status. If you're looking to narrow that down, you can narrow it down by and last active date. If you're looking to do that as well. Below here we have our trial balance option. So if you look at trial balance type selection list, you can see there's three different types of balances that we can run this for.
00:01:26:07 - 00:01:47:08
Brian Hatch
So the first three options are the summary detailed module summary for the net balance. So the net balance is going to look at credit and debit and pull the difference between the two. So if you're looking for net balances, you can run any version of these for a varying amount of detail. The next section down is going to show you all the debit balance options.
00:01:47:08 - 00:02:12:04
Brian Hatch
So these are the the accounts that have an amount due that they would owe you. And if you can get varying different varying versions of summaries on this, depending on what you're looking for or detailed version of the debit balance, trial balance. And the final section is the credit side of things. So the household credit is something you're likely to report on some money that you actually owed them.
00:02:12:04 - 00:02:32:08
Brian Hatch
In those scenarios you have, again, the different versions for the credit balance side of things. So if you're looking for different versions, you can kind of check out those different options here. And again, preparing some amount of detail or summary on the right hand side, you have a trial balance as of the setting. So most commonly people are running as of the date, they're running the report.
00:02:32:08 - 00:02:57:17
Brian Hatch
So living as today is very typical, but you can always pick a day. In the past, depending on your scenario and below that you can set the minimum maximum balance if needed, if desired. By default, it should be listed with all nines and either direction for minimum and maximum balances and a few other options below there for narrowing down by module or including deposits or different settings for what you want to actually print up on the report.
00:02:57:17 - 00:03:19:15
Brian Hatch
At the top you have a module criteria tab. So if you're looking to narrow things down within a particular module for a certain range, you can do that by all modules listed there if needed. Otherwise you can skip that and just use instead of the main core criteria screen. And when you run this report, I'll run it right now just as a quick example for a debit balance summary.
00:03:19:15 - 00:03:38:05
Brian Hatch
Someone had a process just like any other report. You have the option to run it as a PDF or a CSV. It's also very common to run this report and actually have it scheduled to run on a monthly basis is very typical where this would automatically go out to maybe somebody in finance that could review the records on a periodic basis.
00:03:38:07 - 00:03:58:21
Brian Hatch
But you could see with the summary debit balance trail balance report, it's one roll of data per household and you can see it showing me the amount due with a couple different columns listed here. So basic trail balance info and hopefully this is a good walkthrough for pulling this type of report in RecTrac.