UK Reconciling two different systems for debtors control account

[Joylfp]

I have currently joined a company where they run two systems. One is financial (sage 200)whist the other records sales ledger and rent ledger. The issue we have is posting sales transactions directly to customers account to sage because there are hundreds of them. So we have different account code for sales and rent on sage. Which means we journal sales to these codes and bypass debtors control ac because we don’t post to customers accounts. How can we rectify this issue? When we run BS we can’t get a true picture of debtors except we do some manual calculations.

 

[kirby]

You are suffering because you are not using one integrated system. Answer is to upgrade to one system that can handle everything for you. Yes, that costs time and money but otherwise you are forever mired in misery.