Customers and Suppliers
Worklog keeps the people you deal with under Contacts, split into two lists: Customers (the people you sell to) and Suppliers (the people you buy from). Adding someone once means their name, phone number and payment notes are ready whenever you make a quote, invoice or purchase order.
Under each list, the π PDF and π CSV / Excel buttons print it β name, phone, email, address, banking details and how they pay β as you have searched or narrowed it. It is other people's personal information, so POPIA applies to the file as much as to the list. A list you have narrowed says so under the PDF's title.
Open Customers or Suppliers from the menu. Each list has a Search box (a name, their CUS- or SUP- number, or a phone number), then two buttons. Show βΎ narrows the list: to the ones who owe you (or you owe) money, the ones with an overdue invoice, and by payment behaviour on Customers (Good, Slow or Problem payer) or payment term on Suppliers β each choice shows how many it would leave. Sort βΎ orders it by name A β Z or Z β A, by what is still owed (VAT included) highest or lowest first, by their CUS- or SUP- number, or with the ones you changed most recently first.
Add a customer or supplier
- Open Customers (for someone you sell to) or Suppliers (for someone you buy from).
- Tap the + Add button in the top right.
- The Type is already set to match the list you opened β Customer or Supplier.
- In the Name field, type the person's full name or business name. This is the only field you must fill in.
- Add their Phone, Email and Address if you have them (all optional).
- If they're VAT registered, fill in VAT number β 10 digits starting with 4. On a customer it prints on the invoices you send them. On a supplier, if your business is VAT registered, a payment filed against them starts on the claim (VAT on a tax invoice) under VAT to claim instead of asking β still check you have their tax invoice β on a line in Banking β + Add once you have paid them before under the same name, and on a saved entry when you pick them from the list.
- For a customer, pick a Payment behaviour: Good payer, Slow payer or Problem payer. For a supplier, pick the Payment terms instead: On delivery, 7 days, 30 days, 60 days, Cash only or Pre-payment.
- Type anything else worth remembering in the Notes field (optional).
- Optional but worth doing: tap π·οΈ Set category and pick their usual category β the SARS heading most of this customerβs (or supplierβs) lines fall under. Every line on their quotes, invoices, supplier invoices and purchase orders then starts with it filled in, instead of an amber tag you have to set line by line.
- Tap Save Customer (or Save Supplier).
Customers have one extra box: a Custom field for anything unique to your business. Type a Label (like Pet name, Vehicle or Account) and its Value (like Biscuit), and it is saved with that customer. Leave it blank if you do not need it.
Save a supplier's bank details
When a contact is a supplier, you get an extra Banking details section with two boxes: Bank and Account number. It only appears for suppliers (the people you pay), so you will not see it on customers. Fill them in if you would like them handy for the next time you pay that supplier.
Once saved, the bank and account number show on that supplier's row in your Suppliers list, next to a small bank icon, so you can see them at a glance without opening the contact.
Change or remove a contact
- Open Customers or Suppliers and find the person in the list.
- Tap their name to open the contact.
- Change any of the details, then tap Save Customer or Save Supplier.
- To remove them, tap the β on the right of their row and confirm.
Add a lot of contacts at once
If you already have a list of customers or suppliers in a spreadsheet, you can bring them all in together instead of typing them one by one, using the β¬ Import button at the top of the list.
- Open Customers or Suppliers and tap the β¬ Import button in the top right.
- Tap Download template CSV and fill in your contacts using that file as a guide. Only the name column is required.
- Tap Choose CSV file and pick your file.
- Check the preview. It shows a Will import number and a Duplicates skipped number (anyone whose name already exists is skipped).
- Tap the Import button to finish, then tap Done.
