We are moving our development company from Quickbooks to Sage and with it we are having some challenges.

For the development company we put a a good amount of charges on the books as advances for future and current projects. Then after we close on the project the project pays the development company back. In QB we are able to put the charges to an Current Asset account named after the project (with subaccounts for travel, etc), then when we are paid back we can "reconcile" the account to zero. This gives us the ability to pull a GL report for that account and filter out the cleared transactions, leaving us with the actual current amount advanced from the development company. 

My question is is there a way to do such a thing in Sage? As far as I can tell you can only reconcile cash / credit card accounts.