In this video,
I’m going to take you through how to run the Z Report. This is very simple and
useful report that we can use within particular date ranges to show active and non-active
accounts and their balances. Up in your toolbar, let’s
go to the Reports button. Then all the way down to the bottom, you’ll see the Z Report. Just click here and in the next window we can put it in our date range. For the first report I’m going to show you let’s just put in today’s date, so we can just go down to
the Today’s Date button, and then click in the To field. We can hit the button again as well, so we’ve just got today’s date. If we wanted to change that day, we can use the Plus or Minus buttons for day, month, and year, and also beginning of month and end of month, and the same for the years as well. Let’s hit on OK and when we run this report, we want to make sure that the orientation is on Landscape, so select Landscape, and OK. Now, as I’m on a Mac, I
can open this in a PDF just to show you in a preview, so let’s just do that right here. You see we have another window come up saying if we want to
print our Active Accounts or All Accounts, so for
this example right now, I’m going to just show you what happens if we click on Active Accounts. It’s just going to show
us all the accounts that had activity in the date
range that we just outlined and that was just in today’s date range. So this is all of the
active accounts for today. You’ll see that we have our US Dollars and we also have our foreign currencies. We have our opening balance for the day, quantity purchased, quantity sold, any transfers in and out, closing balance for the day, then we have our cost of purchase, which is in our home currency, and then our gross sales, which is also in our home currency. So you see under the US
Dollars, the cost of purchase is going to the same as
the quantity purchased because it’s the same
currency and our gross sales is going to be the same as quantity sold. But if we come down to
our foreign currencies, you’ll see that 750
Australian Dollars were sold, which is the equivalent
to $557.54 in US Dollars, our home currency, so
that’s our gross sales in our home currency. Same goes for the cost of purchase. It cost us $686.21 in US Dollars, our home currency, but we purchased 1,000,
so that’s the equivalent in the home currency. You’ll also notice that all
the way over to the very end, we have the unrealized
gain, so we have that based on the market value at
the time of the transaction. At the bottom, we also
have the grand totals of our gross sales and
our cost of purchase, so a very simple, easy report. I’m going to do it one more time though. I’m going to show you
the difference between clicking on Active
Accounts and All Accounts. So, back up onto our
toolbar, clicking on Reports, and down to the Z Report again. In the date range, we can
keep it as today’s date, or we can change it a little bit. We can say beginning of the month, let’s say, and then up until today’s date. Click on OK, make sure the orientation is Landscape, then OK. I’m going to preview this in a PDF, and instead of clicking
on Active Accounts, this time we’re going to
click on All Accounts. Once this report is generated,
it’s going to show you all of our accounts that we have, whether they were active or
not within that date range. You’ll see that we’ve got some banks, and we’ve got our opening balance, but there was nothing purchased, nothing sold or transferred, and so we have our closing balance, which should be the exact same. But then you’ll see that lower
down in our cash accounts, we have some activity, so we have some quantity
purchased and sold and what that was in our home currency, our cost of purchase and our gross sales. And then the same, if we keep going down, we’ve got all of our
accounts, our expense, our foreign currencies,
showing all the activity that we’ve had in the last month, and then we have the grand
totals at the bottom. And so, this is the Z Report, based on a date range that we enter in ourselves,
showing our accounts, whether they’re active or
not, with our closing balances and our cost of purchase
and our gross sales.