Sales summary rather than sales detail integration with Xero
My business is having trouble generating compliance (BAS) reports in Xero, due to the sheer amount of data coming in from Dear. Xero has provided the below feedback and suggested that our invoicing program (Dear) should consolidate the multiple lines on the invoices by account code rather than listing all the stock items.
Feedback from Xero:
From our data logs for your organisation, the number of Sales Invoices and Purchase Bills have been between 900 and a 1000 over the recent months. As the invoices in Xero increase, you'll continue to experience difficulty with the Activity Statement report, and potentially other areas of Xero as well. It could reach the point where we would be unable to export the report for you.
To accommodate these sorts of volumes, we recommend you look into using a dedicated billing system outside Xero and then sending over a summary of your daily sales. If you're interested in a system like this, we have custom integration partners who specialise in these types of solutions. Please click on the link below if you'd like to explore this option further.
Alternatively, you may like to take a look at other invoicing App Partners that send through sales summaries rather than individual invoices, to reduce the amount of line items that are recorded in Xero.
Hi Dear. We too were extremely frustrated with the quantum of data dear was passing to Xero and then the negative impact it had on our xero environment. In fact we had to dump a Xero instance and start one fresh because the xero account could not cope with the quantum of data that had built up from our dear integration (mostly driven by passing each sold products sku details to XERO where only summary sales and cogs information is required). We run 16 retail locations on our platform. Was hoping the recent launched consolidation enhancements would deal with this entirely. However after running this for a month we have found the resultant payment consolidation logic does not support the sales consolidation.
Whereas the sales consolidation support the dear location / xero tracking categorisation on suncing integration. Payment from Dear are only passed on a consolidated basis to XERO without retaining their location allocation as held correctly within dear.
This results in Xero applying some pro-rata basis the to the various payment amounts types (credit card, cash, gift card etc) across our sales locations/tracking level for the consolidation period. This is completely unworkable for these balance sheet payment accounts as locational control is required across a business to manage risk and banking.
We have had to roll back to non-consolidation until we can convince dear that this addition to payment consolidation is essential.
Is anyone else experiencing the same issue?
i just checked now and the update is released. perfect !
yes! never in one Dear feature I am checking for the updates daily except this.... as we do have synchronization issues with xero almost everyday due to the sheer number of lines of the consolidated invoices exporting to xero. I hope this update can fix this once and for all.
In the product release update webinar I saw on Tuesday, Andrew said it is being released now and are about to receive release notes. So awesome :)
Hi,
Are there any updates on this DEAR team?
We also urgently require the functionality for consolidation to "one line item for each respective Xero sales account' due to exceeding Xero's line limits for the month, restricting our ability to use some of the audit reports.
Thanks
Hello Everyone!
Good news on this!
We have taken this topic up as our roadmap plans and have started primary designs and discussions. Once the development team completes the ongoing work we will take it up. We will share more information on this in the coming weeks.
Please bear with us.
Yohan Andrado Antonio | DEAR Systems Support
Schedule a 30-minute Support call
You may also contact us via WhatsApp +44 1244 940807Continue learning with DEAR Academy
Have a question about DEAR? Ask the Community - Post here and a community member will be happy to help you.
i attached a screen shot for the consolidated invoices from Dear sent to Xero. So.... the invoices consolidated to xero still have 5-8 every day so it's almost the same as non-consolidated. Also the number of lines inside the consolidated invoice is basically the same as the non-consolidated invoice, as each product was exported to xero as well in each line. I think the only thing that this has achieved is, it would not create more new contacts for any new customers in xero....
Hi again Yohan,
I have dug a bit deeper on this issue as we need a workaround. Diagram attached if that is of help to the team.
Cheers,
Steve.
Hi Steve and Monica,
Thank you for the clear explanation here and this is understood! I have forwarded your feedback to the team!
Yohan Andrado Antonio | DEAR Systems Support
Schedule a 30-minute Support call
You may also contact us via WhatsApp +44 1244 940807Continue learning with DEAR Academy
Have a question about DEAR? Ask the Community - Post here and a community member will be happy to help you.
Hi Yohan,
Agreed with Steve. This is still quite a significant limitation of the DEAR to Xero consolidation. We've experienced the same issue.
Thanks,
Monica
Hi Yohan,
Unfortunately, this consolidation function in Dear simply adds every sales invoice line from that day into a single transaction to Xero. So as this transaction has all a line item for every sales order line item, when this gets to Xero, Xero posts all the individual line items to the respective accounts thereby negating the Dear consolidation.
Dear needs to consolidate the sales order into one transaction into Xero with only one line item for each respective Xero sales account not one line item for every sales order line item.
So the Dear consolation function is achieving nothing really.
We have just uncovered this problem for two of our customers.
Happy to talk this through with developers if needed. Hope this helps clarify.
Cheers,
Steve.
Hi Yohan,
Unfortunately, this consolidation function in Dear simply adds every sales invoice line from that day into a single transaction to Xero. So as this transaction has all a line item for every sales order line item, when this gets to Xero, Xero posts all the individual line items to the respective accounts thereby negating the Dear consolidation.
Dear needs to consolidate the sales order into one transaction into Xero with only one line item for each respective Xero sales account not one line item for every sales order line item.
So the Dear consolation function is achieving nothing really.
We have just uncovered this problem for two of our customers.
Happy to talk this through with developers if needed. Hope this helps clarify.
Cheers,
Steve.