I want to ask if there is a feature where the user can import data, specifically Journal Entry. Something like, a user can create a csv of excel file (will be imported to csv) of journal entries, and then import it on managers app. So, user can add journal entry faster.
If you are just concerned with the current year’s accounting, then setup your chart of accounts and enter the starting balances. Then continue with the entries for the current year.
See here Enter starting balances | Manager
If you want to have prior year accounts for comparison, then they can be entered en bloc using a journal entry and the starting balances from the first year.
See here Prepare a quick profit and loss statement | Manager but you will have to include B/S accounts as well
I’d like to raise the ability to import a journal entry again.
I understand that they should be rarely used but, in my case, importing a payroll journal entry is what I’d like. Since Manager doesn’t have a dedicated payroll module, payroll may often be imported into the program from another dedicated payroll program.
Yes, it does. See the payroll section of the Guides.
That is true. But you would probably not be using journal entries. If using a third-party processor, you would use payments to record amounts transferred to the payroll processor for various purposes. If just using another program to compute payroll amounts, you would still use Managers to record payments to employees.
Just what type of journal entry are you thinking of?
Thank you for responding. For example, I have created my own payroll module in Excel that calculates statutory payroll deductions, prints the cheque and posts the transaction to the employee ledger using Excel VBA macros. To integrate that Excel payroll module
to Manager would save a lot of time.
I am, however, going to look at the “Batch Create” ability in Manager which may answer my concerns. I was not aware of this. Give me some time and I will come back to post an update.
Yes, I plan to import totals into Manager and I’m currently experimenting with the batch import feature. When you go to journal entries and click on batch import, I get the fields required to be populated for the import. However, does anyone know which field is the General Ledger Account field? I can’t get that field imported correctly. Also, what is the correct syntax for that field ie. account number and account names? like “500 Wages” ?
Thank you everyone for your help and guidance. Obviously, Manager has much more functionality than I realize and I’m going to have to take some time to further educate myself in some of the suggestions placed forward.
Ok, so I’m continuing this thread again and am back at asking a question about the journal entry batch create function. I’ve been experimenting with this and have figured out how to obtain the UID value for the account code. It all works well except that every line in my batch journal entry, which is basically one balanced journal entry, becomes a number of journal entries for each line. Each row in my batch journal entry is posted as a separate journal entry and they are, obviously, all out of balance because there is no matching debit or credit.
Is there a way to post a batch journal entry that may consist of several lines as one journal entry rather than divided up into a journal entry for each line? Maybe there is a particular field that must be completed to identify it as one journal entry.
Each row of the spreadsheet is a single transaction. Notice all the variables with names starting with Lines.*. Such a variable contains all the content for every line in the transaction corresponding to the *. That could be descriptions, accounts, quantities, etc.
Hi Tut and thank you for your response. Each journal entry must have at least two lines or two transactions. That is, there must be a debit to one account and there must be a credit to another account for the entry to balance. How is that achieved with the batch create function?