Is there ant excel sheet to upload bulk entries thru Batch Create option. In uurrently available option we need to punch the Account Name & Amount in same cell making it in more than 1 rows
-
enter some representative data into Manager via the normal manual method
-
Do a batch update to see how that could have been entered via a batch create (the format is identical except for the final Key field)
-
format your batch create to enter the data required.
Notes
-
you are likely to need a VLOOKUP to find the GUID values downloaded from batch updates in other tabs
-
Transactions with multiple line item need multiple lines entered in a spreadsheet cell. How to type that varies with spreadsheet. In LibreOffice type shift return