Hi,

Thanks to this forum that I have learn a lot of skill and knowledge about Sage. Recently, I am working on a project, and I am wondering if I could do it in a efficient way.

Here are my situations:

1. We have more than 20 sage 50 files setup for all our companies.

2. We will need to generate an update bank balance report for the 20+ companies few times every month according to our bank ledger balance (this will include all outstanding cheques).

3. Now we will need to open all 20+ sage 50 account trial balances to manually update our bank balance report (mistake might occur as it is manually typing) few times a month.

4. I have built a spreadsheet to capture all the bank balance if I exported the trial balances to excel files. (This eliminates all the typos when entering the balance)

5. We need userID and password to log in to the every Sage file. 

I am wondering if there are any ways that I could export all the trail balance from the 20+ sage files in a more efficient way (time saving). Or if there is an actual method that I can retrieve the ledge balance from multiple sage 50 files all at once.

Thank you in advance,

Alvin