It does not need to be difficult. Set the petty cash fund up as a bank account instead of a cash account, as was mentioned above. Generate a statement inlanders .csv format. Import it. Contrary to comments made earlier, only one import is necessary, not two. And you would be free to design both receipt rules and payment rules that would operate on the same import.
As @Tut mentioned and as I advised just treat a petty cash account as a bank account. However, what has not been answered is why they are treated so differently and the only wild guess I can make is that it depends where you are working from. I support restaurant, retail and farming businesses in Nigeria and let them use our Server edition to do their accounting. However, retail and restaurant in Nigeria is about 60% cash and 40% card while farm is much more cash than card. So being largely cash based and mostly recorded by hand it would be easier for the cash accounts to be entered into a spreadsheet and reconciled like a bank account. However, Manager allows one to setup bank accounts that are not real so hence no problem. Restricting cash as it does at the moment in my view is pretty artificial but probably there to prevent people making mistakes.
Manager allows things until it doesnât at some point. This is extremely unnerving especially if you have past experiences like I did when I had to redo tons of work at my own expense just to correct for the effects of such changes. Thatâs why I donât think that what you and @Tut propose is a true solution.
If Bank and Cash are truly the same thing, then I suppose they should have the same utilities otherwise, why would anyone still keep the distinction between the two?
Also, it doesnât look professional on my part and on Managerâs part to categorize cash accounts as bank accounts when you have the option otherwise. Clients donât really care for lengthy explanations why we had to do this workaround, it would look hacky at best.
1 Like
Because the control accounts are different. Most people do not want petty cash being reported as Cash at bank.
True, but you can avoid that problem with custom control account, named as you wish, making the difference almost undetectable.
True, but what is also hacky is trying to import an excel spreadsheet you created and calling it a bank statement. Most petty cash funds, tills, etc., do not produce statements. Those are what cash accounts in Manager are designed for. Wanting to import a statement from a cash repository seems like the fringe case.
Youâre missing something. You can have multiple control accounts for bank as well as multiple control accounts for cash. That means classifying them under different control account is not why you separate them to begin with.
If thatâs the only reason thereâs to it, then the separation is completely unnecessary.
I disagree. Most retail businesses rely on POS systems to record cash transactions and while Manager offers no native POS, it should at minimum provide sufficient utilities for import of data.
Also, many (if not most) businesses have cashiers who are not qualified accountants and who need daily closing procedures before the cash movement is reconciled, approved and posted. Manager is lacking severely in that regard â like most other systems â however, unlike other systems it makes it difficult to have your own external controls what with the arbitrary restrictions on what you âshouldâ or âshouldnâtâ do.
The way I see it, if you canât provide users with adequate cash controls, at least allow them to import the results from wherever they please so they can have their external controls.
I have thought having separating âBankâ and âCashâ accounts was a strange division given the main difference I could see was
- no transaction import
- the name
Another big difference is the availability of reconciliation.
You may remember we have been down this road before. Bank and cash accounts were originally distinguished only a checkmark for âThis account is maintained by a financial institution.â Then they were completely separated as they are now. Then they were combined, all being called cash accounts, which reported under a control account called Cash and cash equivalents. Then they were separated again.
They have had separate transaction tabs, too: Bank Transactions and Cash Transactions. Now we can use receipts and payments for either. I do not know what drives all these changes. But there seems to be something all of us are missing.
2 Likes
So in summary, there is nothing which a cash account can do that could not also be done with a bank account. But if an account is designated a cash account then you canât
- import transactions using bank rules
- use Managerâs reconcile functionality.
It maybe worth including this in the guides. Perhaps in https://www.manager.io/guides/11727
Cash accounts are also reconciled against external registers and cash counts.
I donât think there should be any difference here. 
2 Likes
Is this function available yet?
No. The lengthy discussion included several ways to accomplish POS cash imports. I doubt any program change will occur.