IIF upload file made some expense accounts disappear from Profit and Loss/ reporting
We are using Reckon Accounts Enterprise 2022. Just wondering if anyone has come across anything like this before?
We created a new IIF file that will import multi-BILLs into our Reckon test file. Did have a few issues with it but eventually fixed the issues, including error messages on the ENDTRNS lines that read 'can't record invalid transaction'. All the bills are successfully imported in to the Reckon test file. Checked via payable reporting, and randomly test check a few to see if the split lines (for expense codings are correct), with the right amounts too. Everything seemed to be in working order.
Next check we did for compliance is to ensure no incorrect accounts created in the process (sometimes new bank accounts can be created, which should not be the case). To my surprise, the P&L did not show the accounts (these accounts are 6310 onwards and the refreshed P&L after upload showed 6200 numbers at the last one. They were not in the summary nor were they in the detailed breakdown.
I have taken some snapshots of what the file looks like and the P&L before and after
IIF file snapshot (in Excel)
Bills were successfully imported, shown in the AP Ageing report
P&L before IIF import/ upload
P&L after showing the last number before total expense to be 6200+ (it should technically go up to 6500+ as shown above)
Any thoughts on this or help at all is appreciated.
Thanks and regards,
- All Categories
- 6.7K Accounts Hosted
- 5.9K Reckon Accounts (Desktop)
- 3.2K Reckon One
- 144 Reckon Payroll Upgrade for Reckon One 🚀
- 10 Reckon Invoices App
- 1.1K Reckon Payroll App & Web
- 12 Payroll App - Help Videos
- 18 Reckon Mate App
- 14 Reckon Insights
- 107 Reckon API
- 946 Payroll Premier
- 115 Payroll Premier upgrade to Reckon Payroll ⤴️
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 68 About Reckon Community