I am completely beside myself with what is being referred to as “batch” and “action” because the 2 are not compatable in this system.
It does absolutely no good to import anything if there is even one necessary field missing in the transaction, espeically the freaking amount.
First, only importing bank statements a month after they occur, is absolutly ridiculous in accounting.
Then the bank statements include partial information. There is zero accounting information except for banking credit and debits. That is not enough information to reduce time manually entering.
Then when you attempt to do it the right way, from the first action taken, which spans across the chart of accounts, including items linked to accounts, then you cannot import all of the information.
So, in an attempt to do it backward to move forward, you manually enter some so you can “copy to clipboard” and then add the relevent data from those speardsheet headers, nothing imports, not even the freaking amount!!!
After all these years this has been “developed” I see zero development. If you are not going to do EVERTHING right in accounting, you should be doing ZERO accounting functions!!! And yet after all t his time not one person can come up with templates for this as the entire community is complainging about the exact same thing!!! That tells me you should be doing ZERO coding functions as you are costing the end user more time and money is trying to fix your “bugs” that are actually and infestation!!!
If you cannot play a game you surely should not be coaching!!! Freaking common sense is gone in this pathetic world as no one wants to be held accountable for their actions that cause other people damages in their lives impacting their time and money and their actual commitment to their customers, a totally lost concept anymore THAT I INSIST UPON DOING FOR MY CUSTOMERS AND THIS SYSTEM IS A FAILURE IN ACCOMPLISHING THAT TASK!!!
First you need to do manual entries to be able to see what headers it attempts to use in order to create the spreadsheet, then update it, or what they really need is a batch recode and update because it is not bringing in any of the data that is relevant to an EXPENSE CLAIM such as the expense claim payee, the item or even the account impacted, the amount, the project and the division, it does not work no matter how much editing is done. It takes less time to just manually enter the data yourself rather than trying to fix the spreadsheet a million times.
It is such a simple task. Whatever is in the default form for the transaction should be the header in the spreadsheet and it is not, even when you have properly coded transactions, copy that clipboard, use those headers and then add the data, then batch create. I should not have to go into hundreds of transactions one by one to manually have a payee, supplier, amount, project and division when that information is already in the system and should automatically recognize it.
I am not t he only one with this same issue, it is all over the forum for years so why hasn’t the development team just created a template for each transaction type and then it actually work when you batch create. Simple solution. What is the issue still such a problem?
I have used Batch operations successfully and they work reasonably effectively. I only use the desktop version, so I cannot speak for the server or Online versions.
I would suggest that the best way to get help is not to just complain, but to ask specific questions about the issues you are having - illustrating with screenshots of the attempts you have made.
Having said that, I do have frustration with some of the half-baked features of Manager_io that never seem to be developed to their full potential and the continual introduction of new features and changes before other features are taken to maturity.
This is the reason that I am “voting with my feet” and I am making preparations to move to another accounting program.
There are none out there without the intrusive and predatory AI. I know what it is doing to people and the information it is stealing and selling not only to the general public but also those with nothing but evil intentions.
All I want and need, is the headers for the columns for Manager to import data. Importing bank statements then moving backward to classify everything is not the right way to do this, in any accounting system.
So, for expense claims, what are the headers for:
Paid by – should be the expense claim payee
Payee – should be the supplier
Item – should be item
Account – if not item, then should be account
Project – should be project
Division – should be division
But when this data is imported it is not actually being imported. The fields are empty, even when I use a clipboard from correct transaction. It does not import.
Same issue with receipts, payments, sales invoices, purchase invoices, journal entries and inter account transfers. None of them completely import the data that takes a lot of time to put together.
You haven’t said a thing. You need to use screenshots to illustrate your process and then you can get help.
Sometimes if you want to batch create. Do test batch update to get the correct fields in your spread sheet and delete irrelevant columns. Batch operations is one of Managers most powerful tools.
Batch Create can be used with Inventory Items, but Project and Division cannot be applied to an Inventory Item in a transaction line (either imported or manually)
A Division cannot be applied to a Balance Sheet account transaction line (either imported or manually)
To get all the Header Names for the import file columns, first enter a manual transaction that is identical to the transaction(s) you wish to import, and then use Batch Update to get every header column.
If you are creating new transactions (Batch Create) be sure to delete the Key column (usually the last column)
For the new transactions modify the data of the initial transaction as required but keep all the data that does not need modification
Copy all and every column (except the Key column if doing Batch Create) to paste into the import function.
Creared, manually, 5 expense claims that include correct data in all fields in the default forn
Copied to clipboard.
Pasted in excel.
Deleted data in rows under row 1, beginning in row 2, and adding new data.
Tried both batch update and batch create with all data in spreadsheet and neither imported all data. The amount header copied from manually adding data does not even import.
So I even copied and pasted the empty clipboard to see all headers. A simple solution is to have an AKA header name that reflects the name on the default forms. Not everyone is a coder and can interpret what the headers from the empty clipboard represents.
Simply, there is no reason to struggle with having transaction templates that non coders can use. Simplicity is the key to successful imports. It almost appears that there is no intention of needed improvements regardless of numerous complaints in the forum for years. Common sense tells me this should be detailed in the GUIDE that is worthless.
And expense claims, hundres of them are for non inventory items such as fuel and out of town job expenses, paid on several owners personal credit cards, and in this clean up is over 2,000 rows each year for 3 years. And from what you said none can be batch imported. The very theory that a business owner would use personal credit cards for inventory items is not even rational. Neither is the fact that I manually enter transactions and they cannot be exported and then imported with new transactions is not productivity in action when you have to manually edit each transaction. Majes no sense.
Here’s the THING that I failed to mention dozens of times thus far. Since you need pictures here you go. Here is a picture of the blank clipboard that is copied into Excel from Manager.io with the header names for columns. Each one highlighted represents pertinent data to be imported. It doesn’t do it.
Batch Create can be used with Inventory Items, but Project and Division cannot be applied to an Inventory Item in a transaction line (either imported or manually)
Here you stated inventory items, when I attempt to put a non inventory item into the spreadsheet for import with the header Lines.1.Item it does not import, even with or without the next column Lines.1.Account With or without data
A Division cannot be applied to a Balance Sheet account transaction line (either imported or manually) it wasn’t a BS account it is a P&L expense account
To get all the Header Names for the import file columns, first enter a manual transaction that is identical to the transaction(s) you wish to import, and then use Batch Update to get every header column. See the screenshots
If you are creating new transactions (Batch Create) be sure to delete the Key column (usually the last column) I did this
For the new transactions modify the data of the initial transaction as required but keep all the data that does not need modification I have done this
Copy all and every column (except the Key column if doing Batch Create) to paste into the import function I have done this
It just is not importing and I have been working on this for days.
Modify the data to represent the new transactions - (most Likely) Date, Payee, Lines.1.item, Lines.1 Qty, LInes.1.PurchaseUnitPrice, Lines.1.Project, Lines.1.Division.
Thank you so much. Im calling it a day and will try tomorrow. I only will use these for clean up clients as i go into all bank, credit card and LOC accounts each day to update since we cannot get bank feeds in USA.
Since being an Intuit Advanced Pro Advisor since 1993 I’m leaving Quickbooks and was seeking old school alternative similar to original QBDT, no more AI.
I’m sure your solution will work. It’s just sad a guide doesn’t include real road blocks and how to overcome them. Your solution should be included there.
There was a more comprehensive guide in the past, but it has been replaced with one which only gives an overview of topics and an AI bot that continually hallucinates.
Okay that worked. I guess the best plan of action is to keep another spreadsheet with all of the corresponding coding language for suppliers, items, accounts, projects, divisions, etc (anything with coding language rather than human language) in order to correctly identify each cell input. It would be beneficial to have drop down list for templates but then each time you add anything it would need to be update for the proper importing information.
It just seems like the developers would have made this more user friendly, after all it is the user that uses it right?
