Morning all,
I’ve been sent a spreadsheet of expenses to key in and was hoping, really really lots, that I could bulk import purchases. However, for reasons I dont know I’m getting this nonsensical error of “Error reading totalAmount” .
Now, I’ve googled this and have tried the following;
- Copy a section of this to a brand new sheet in case of any hidden cells, text, formatting etc - same error
- Renamed D1 from “Total Gross Amount” to “TGA” incase QF can’t handle spaces in a row - but it’s its fine with A1’s “Receipt Date” - same error
Whats weird is that another batch imported absolutely fine! WTH?? Same format, layout etc etc. Unless QF is having a monent I just dont understand.
I’m going to start manually keying these but I have 46 rows of other expenses to key in so would reeeeeeeeeeeeeeeeeeeeally love it if someone could explain to me, like I’m a child, what I’m doing wrong here.
Thanks in advance,
Lu