Hello all,
Despite my minimal accounting knowledge, I find myself handling A/R responsibilities at my company. Our accountant wants to see numbers in a specific way and I want to toss this out there to you pros to see if anyone can help me accomplish what he's looking for in Sage 50. Please let me apologize in advance if this is a silly question.
We currently use another program to do all of our billing and receivables for my department. I can generate all sorts of reports from this program. The issue is that we are currently posting total daily receipts to Sage as one line Receive Money transactions, but there is nothing to post them "against". We have a GL code that we use, but there's no "invoice" to apply them to.
Long story short, what we need to do is create some sort of a monthly total billed transaction "invoice" from this other program that we can then apply the daily payments against so we can see where we are as far as what's been paid vs. what's still owed and a way to track sales taxes charged and paid. The way we have been calculating sales taxes is based on what we've received and not what's been billed and "owed" to the state. So we're mixing cash and accrual basis accounting, which I understand is a no-no.
Is this a General Journal situation and if so, would Sage be able to automatically decrease the amount owed by entering payments daily?
Thank you in advance for your help! 
