Keep your list of accounts in Account Masters

Account Masters opens the list of every account: parties, banks, expense heads. The screen header reads Address Book, because each account can also hold an address, phone and GST number.

On this screen

1. Tick marks rows for print, export or messages
2. AccountName type letters in the list to jump here
3. OpBal opening balance, with D or C beside it
4. Edit opens the account form
5. Del deletes an unused account after a question
6. Ledger opens this account's Ledger
7. SMS / Whatsapp message the ticked parties
8. Export sends the list to Excel

The list

Typing letters or digits in the list jumps to names that start with them. The typed text shows in the header. Backspace clears it. Arrow keys, Home, PgDn and Del reset it. The column headers can also filter and sort.

The buttons

The Birthday Reminders and App buttons do nothing in this version.

Export the list

1. Open the panel
   Click Export.
2. Choose what balance to send
   Under Export What...?, pick Opening Balance, Pick Closing Balance or No Balance (0 Op. Bal.).
3. Choose which accounts
   Selected Accounts Only (ticked rows) or All Accounts.
4. Export
   Click Export. E-Lab writes 47 columns to an .xls file in the Temp folder of the E-Lab folder, says the export is done, and opens it in Excel.

Import accounts from Excel

1. Get the layout
   Click Import, then View Sample File. A blank sheet opens with the 47 headings. Fill your accounts on the sheet named Sheet1.
2. Step 1
   Click Browse Excel File and pick your file.
3. Step 2
   Pick Import as All Accounts are new From Excel Sheet, or Overwrite existing accounts with new account details. Type No. of Records, or leave it 0 or blank for all.
4. Step 3
   Click Import Data. The status line shows each row, then "Imported n Accounts".

• A name that already exists is skipped. With Overwrite, an account whose AccountID column matches is overwritten.
• A group name E-Lab does not know is created under Sundry Debtors.
• Dr or Cr comes from the D/C column, or from the sign of the amount.
• A Party Type outside the allowed list becomes N.A.

Send SMS or WhatsApp to many parties

1. Tick the parties
   Only ticked rows get the message.
2. Open the panel
   Click SMS / Whatsapp.
3. Pick a template
   Double-click one under Select SMS Template to Send. These are the templates saved for Address Book in SMS Templates. Define a new SMS Template opens SMS Templates to make one.
4. Check the text
   Total Characters and No. of SMS (one per 160 characters) show the cost. Fill Template ID if your SMS provider needs it.
5. Send
   Click Send SMS or Whats App.

Words in braces are filled for each party. The useful ones are {Account Name}, {Current Ledger Balance}, {Dr. / Cr.}, {City}, {Mobile}, {Name of Company} and {Current Date}. The full list also has {Party Name}, {Group}, {Opening Balance}, {My Ledger Balance}, {Full Ledger Balance}, {Address Line 1}, {Address Line 2}, {State}, {Phone}, {Email}, {Contact Person}, {Bank Account No.}, {Bank Name}, {Cheque Printing Name}, {Party Type}, {VAT No.}, {CST No.}, {PAN No.}, {DL No. 1}, {DL No. 2}, {Credit Limit}, {Bill Limit}, {Credit Days Sale}, {Credit Days Purchase}, {Birthday On}, {Anniversary On}, {Audited Upto}, {GST No.}, {MyShop App Download Link}, {1st Add. Field} to {10th Add. Field}, {U.Card No.}, {User Name} and {Current Time}.

Questions people ask