I’m trying to match the quantities of securities in Manager with various investment accounts.
I find Manager very, very flexible so there is generally more than one way to use Manager for the same purpose. Maybe you can tell me whether what I am doing is needlessly complex when there might be a simpler way.
I have Bank Accounts, Inter Account Transfers, and Inventory Items enabled.
I have one Manager Bank Account for each Stock Brokerage Account. If the balance is Debit (or positive), then I have cash in my account. If the balance is Credit (negative), then I have a Margin Loan. I find this simpler than having a Cash account in Balance Sheet Assets and another Margin Loan account that appears in Balance Sheet Liabilities.
Manager makes reconciling with an Excel spreadsheet very easy: I download from a bank my account transactions. I export from Manager my transactions for that bank account. I do some database types of actions. I group by amounts and count the number of each amount. I do the group action for both sets of data and then compare. A perfect match of each amount and its count proves a match. When the two sets of data do not match, I have a list of amounts and counts that only appear in the bank’s records, and a list of amounts and counts that only appear in Manager. Manager makes it easy to search for those entries that only appear in Manager.
Now that I turn to my investment accounts, seems I can do the amounts comparison the same as with any bank account. The investment accounts are different, though. I need to check that the number of shares matches.
So now, I am searching for where I ought to get the data in Manager to reconcile the number of shares (or options or bonds, etc.). Exporting from the Inventory Items tab does not work because it does not say the location. Analyzing the Batch Update data does not work because it doesn’t show the location except for starting balances and because the location is given as a GUID, so I still don’t know the location.
In Reports, looked like the Inventory by Location might be what I want. I was a little startled that I do not need to create a report. Looks like there is no way to specify the reporting as of a particular date. It does not show the transactions, just the total quantities.
But all this may be okay. I can download the present account positions (which are also totals) from the stock broker. I can match against these totals in Manager. And Manager makes drilling down to the transactions easy.
To really communicate clearly, I might have to write a better description of what I am doing with examples, maybe a pamphlet. However, I would rather not spend the time writing the equivalent of a pamphlet, and I am sure you would not want to spend the time reading it and working through it. What I am hoping is that you can get a rough idea (but good enough idea) of what I am doing in my reconciliations.
Maybe you get a good enough idea what I am trying to do to recommend using the Inventory by Location Report or some other Manager source of data so I can make sure I have entered the number of shares is correct.