When migrating to Wafeq, you will most likely have customers’ invoices and vendors’ bills that are still outstanding. The balances of these outstanding invoices and bills need to be imported into Wafeq as opening balances for your customers and vendors.
Learn by watching
Watch this video on how you can set up customers’ and vendors’ opening balances or read on below: Setting up customers and vendors opening balances
After you've set up opening balances of your customers and vendors, you'll be able to:
- Keep track of your accounts receivable and accounts payable balances
- Keep track of the amount of money that your customers still owe you and the amount of money that you still owe your vendors
Say you are moving to Wafeq on the 1st of January. You will need to import all your unpaid invoices as of the 31st of December.
To prepare your invoices CSV file, go to Invoices in the left-side menu, click on the Import button, then the on the link to download the CSV template. In this spreadsheet, make a list of your unpaid invoices and their balances.
To import the invoices balances only:
- Set the Quantity to 1.
- Set up the amounts in the Price column to be equal to the balance amount.
- Set the Status of these invoices to SENT.
- In the Account column, enter the Opening Balance Offset account, because you will be recording the opening balance of the invoice only.
- Import this file into Wafeq.
- Map each column of your CSV file to its corresponding column in Wafeq.
- To verify the opening balances of the imported invoices, go to Reports in the left side menu, then to the Statement of Account tab. To get your customer’s Accounts receivable opening balance on the 1st of January, use the Contact filter to filter the report by your customer’s name and set the To date filter to the 31st of December. You will see that each of the customers’ Accounts receivable opening balances on the 1st of January match the balances on the CSV file.
If you remove the Contact filter, you will notice that the imported invoices increased your accounts receivable total balance by the total amount your customers owe you as of the 1st of January. This change in your Accounts receivable opening balance is also visible in your Balance Sheet.
Notice that we haven’t applied any tax rates to the invoices because any taxes due must be imported separately as part of setting up the opening balance of other accounts.