I totally understand where you're coming from. I also sell through Amazon FBA and used to track everything in Excel, just like you. I would only record the deposit from Amazon as income in QuickBooks, but that never gave me a full picture of my business. My reports were always off.

When I switched from QuickBooks Desktop to Online, I started using Synder to help with the Amazon integration. It connects directly to your Amazon FBA account and pulls in all the details automatically and everything else Amazon takes out before depositing money into your bank.

Synder also matches those deposits with your bank feed in QuickBooks, so everything lines up. You get a much more accurate view of your income and expenses, and you don’t have to do all the work manually in spreadsheets anymore.

If you're moving to QuickBooks Online and want to track everything properly, I really recommend giving Synder a try. It made my life a lot easier and helped me keep my books clean and up to date.