Level 1

Monthly Subscription and Sales Accounting


We are a non-profit and our members send us their monthly subscription dues as a transfer from their bank. We don't generate or send invoices. We have an income category called "Monthly Subscription Dues", and we tag all the incoming bank transfers to this category. Unfortunately, this category is not setup as a subset of "Sales" category. 


So this creates the following problems:

1) Though the money we get shows up as income; it does not show up as sales. So reporting does not reflect the sales that we made on a monthly basis. I can work around this by generating income reporting. 

2) For each of our members, I cannot figure out how money they have paid to date. In Sales, under customers, customer name, it shows no transactions. So I cannot determine if the member paid their dues this month or last month. 


Is there a way to fix this. I have a work around for my #1 issue, but I really need to find a solution to my #2 issue. 


Please help.