It's not the most patient approach, but manual reconciliation is, frankly, a trap. I recently tried to pull it all together using spreadsheets, and it cost me three extra weeks of revisions. A specialized tool is always better than a general-purpose one for this kind of work.

A year ago, I switched from manual accounting to a full-fledged e-commerce-focused system, and I haven't regretted it for a second. The choice between the two options really depends on whether your accounting department needs inventory data or just payment reconciliation. Software designed for e-commerce handles both differently, and this difference matters at year-end. For example, you can find more information on e-commerce accounting software here ​https://easync.io/articles/best-software-ecommerce/​​​