u/picontesauce

We have a seperate POS system that tracks our sales. For Simplicity we record sales amounts on a cash basis from the Bank Transactions. Which works fine.

BUT we want to start adding our monthly outstanding A/R, so we can run our Financials in Accrual and be able to see our sales including the A/R. So what would be the best way to get a lump amount to show up as an Accrual sale without actually having it tied to anything?

A journal entry won't work, because it will show up in both Cash and Accrual basis. And creating a sales invoice doesn't seem to work because when the A/R goes down, I'd need to mark it as paid which would affect our cash sales, which are already recorded through our bank transactions.

Does anyone know how to get a report to show the full memo line when exporting to Excel. After a certain length, the report just gives you the ..... And I really need to get the full memo onto an excel report. Any suggestions would be loved.