At the end of each day (or any other specified period) I would like to be able to generate a report of total payments received for that day (or period) by cash, card or direct deposit. As I record payments each day I specify how the payment was made by use of added custom field (cash, card, direct deposit). Is there any way I can generate this report. I just need to be able to report on the amount of cash received, card payments made and amounts paid direct to the bank at the end of day (or other date range). Thanks.
have you checked Cash Summary under Reports?
That report won’t help, because it doesn’t list transactions by bank or cash account. It basically draws on the other side of every transaction, reporting on the balancing accounts of amounts that went to or came from cash and bank accounts.
This seems unnecessary. The account into which the payment was deposited is specified by selection of the account at the top of the payment form:
To do this, you will have to assign your bank and cash accounts to individual control accounts so they show separately on the balance sheet instead of being grouped under the default control accounts of Cash at bank and Cash on hand. Then the General Ledger Summary report will tell you directly what you want.
If you have only one bank account and one cash account, you won’t need custom control accounts for those, because the default account will give what you want. But you will need a custom control account for the credit card.
When I set manager up, so I didn’t have too many tabs, I only selected bank accounts of which I added two. One account for petty cash and the other as the main operating account. All transactions excluding petty cash go into the same account. That is why I added a custom field to specify cash, card or direct deposit. My setup most likely complicates things. Given my setup is there anything I can do to achieve my desired outcome?
first thing you would want to do is convert your petty cash account to an actual cash account in Manager.
read this guide Manager Cloud
Given that you’ve mixed multiple account types into a single account, there is no way of separating them. As far as Manager is concerned, they are indistinguishable transactions in a single account. Those custom field entries are not examined in any way by the program. They might be useful information for you, but not for the program.
Depending on how long you have been using Manager, you could either unwind your existing setup by creating proper bank / cash accounts and then editing the past transactions to their correct account, or, draw a line under your existing business and create a new business with the correct bank / cash account setup.
So either way I will need as you say to create proper accounts. “Cash on hand” for the daily payments, “petty Cash”, “Cash at Bank” for the direct deposits. “Card Payments” for that received by card. Is this correct, 2 cash accounts, 2 bank accounts? I will convert the petty cash acct as suggested first.
Cash on hand and Cash at bank are control accounts. They present summaries of cash and bank accounts. So you only need Petty Cash, Bank Account, and Credit Card.
I think I have set up my accounts as suggested and all “seems” to test fine. I have stand alone bank account and then card payments acct with control acct card payments. I have stand alone cash acct for petty cash and another for cash payments. I will soon roll back my transactions to reflect the changes. One issue though is that I tried an inter account transfer from bank account to petty cash and the result is an increase in cash on hand as opposed to the petty cash account.
That is because Cash on hand is the control account for your Petty cash account. Unless you create separate, custom control accounts for every cash account, the will all appear in the Summary under Cash on hand.