Importing Transactions from Spreadsheet

[AS_Grya]

Hi everyone,

I have started new business and recorded all transactions in spreadsheet until I found Manager.io Now, I have tried importing the existing transactions through batch operations but I am facing problem with matching the data to correct COA account codes.
And even Paidfrom code is not picking during batch clipboard operation.

Can anyone please help me how to resolve this issue or give me right direction so I can add all previous transactions. There are around 6 months data to be imported.

Thank you

[Patch]

To get the batch create format correct

• Manually enter a variety of representative transactions
• Start a batch update for those transactions
• paste this in to a spreadsheet
• Look at this data carefully, the fomat is exactly what you would have needed to construct (except for the final Key field) to create these transactions using Batch create

[AS_Grya]

I have done as you said but still not able to import it.

1. add transaction
   

   

2. copied to spreadsheet from batch update
   

   

3. Create new transaction in spreadsheet to Test
   

4. Pasted in Batch Create - but it doesn’t match with correct accounts.
   

   

can you please guide me what I am doing wrong here?

Thanks

[Joe91]

The number format of the cell containing the amount is different in your two images

[Patch]

@AS_Grya

add transaction

No you need to add a variety of transactions manually in Manager first.

Batch update will then show the range of cases you need to handle and how each differs

Then you have the information to program batch create (provided you have the programming skills)

[AMM]

Go to Payments
Click Batch Operations
Batch Create
Copy to Clipboard
Paste it to the Spreadsheet
Fill the following only

Copy the contents upto column BI including the blanks
Past it
The Result will be

And

[AMM]

If the data in your spreadsheet is clear and perfect its a matter of an hour or two for whole 6 months data

[Ealfardan]

Just to make it more obvious what @AMM has done here is correct the format of the accounts data which he made sure to highlight in red.

For example, in the field PaidFrom he used the code 1001.

@AS_Grya, you can either use the unique code or the UUID. Any other text strings like account name will cause Manager to ignore the entire cell content

[AS_Grya]

Thank you sharing this.

I have tried what you shared, but it works on few entries I tried and doesn’t work on each time.
This sounds weird but it’s not importing correctly each time.
Upon testing different transaction types I found this issue, and sometimes the one which worked before doesn’t import next time.

Not sure what to do now

[AMM]

I am sorry, it can’t be
Inspect your data
As @Ealfardan mentioned above consider any other text strings being included
I have done it many times in 100s
If you are using cloud check your internet which may be unstable

[AJD]

Some troubleshoot items:

1. When batching new entries (Batch Create) there must be no “Key” column
2. Do not use currency symbols in amount fields (or format spreadsheet cells as currency)
3. In cells that refer to accounts use only the account code (or UUID) and nothing else.
4. I prefer to use codes for all accounts as I have found that UUID’s sometimes do not work correctly
5. Ensure that account codes used in the import spreadsheet exist before importing Receipts or Payments via Batch Create.
6. After each import check to see if any entries have ended up in the “Suspense” account.

[AS_Grya]

It worked @AMM , my error was using few wrong accounts and it failed the import.
Otherwise what you suggested is working. Thank you very much!

[Ealfardan]

Glad it all worked out eventually

[james505]

Could Manager.io share a template or sample csv file with all possible criteria?