We had a demo session with a fastest growing car dealing and auction broker in Lagos last week to discuss the scope of QuickBooks software implementation and how they could effectively monitor their cash flow on a real-time.
During our conversation, the panel of managers was concerned about tracking foreign currency transactions; their model is in such a way that car buyers prefer to pay in Naira while they, as a licenced car auction broker, bid on various car brands online, handle all landing cost and settle the bills in US dollars.
Businesses like this require an affective foreign currency translation processes and real-time exchange rate update in order to get their books of account right.
How then could QuickBooks solve their financial management challenge, key personnel ask?
To answer the questions, we will divide their business transactions into four (4) key parts:
- Domiciliary account setup and exchange rate update.
- Creating a foreign seller account and bills to track all payables in USD, including shipping fee.
- Creating another service provider account to track custom duties on the car imported.
- Invoicing the customer in Naira to record receivables and receiving payment into a Naira bank account.
Domiciliary account setup and exchange rate update.
We have already shared a complete guide to adding your domiciliary bank accounts in QuickBooks and updating your foreign exchange rates in one of our previous posts, click here to learn more
Creating a foreign seller account and bills to track all payables in USD, including shipping fee.
If you had read through the guide above, the rest shouldn’t be a challenge; go to the “Supplier or Vendor Centre” and create a foreign supplier which, in this example, is the car auction seller or company based in the USA.
- At the top left, click on “Add new”.
- Fill in the sellers’ details > Enter an outstanding balance payable to the seller > Select the currency you would be paying when settling the car auction price.
- Click on “Save”.
After creating a supplier’s account, you can now proceed to add a “bill” or “write a check” to track all USD payables or payment respectively to the total foreign transaction cost of the car, including shipping and freight charges. The “bill” is used for auctions that are yet to be paid for but is already won while the “write a check” window tracks upfront payment on auctions.
Creating another service provider account to track custom duties on the car imported.
By law, every importer is required to pay a customs duty on cars imported which is determined by the estimated value of the car. Such tax payable in Naira would also be tracked via the “write a check” window, mapped to “Custom Account” under suppliers name with the relevant bank payment account selected.
Invoicing the customer in Naira to record receivables and receiving payment into a Naira bank account.
You can also use “Create Invoice” to record the car details, amount charged, and VAT deductions receivable from customers. This will help you create a “Customer Receivable Account” that checks your expected cash inflow.
From our conversation, we also understood that they always request for an upfront payment on car orders before, proceeding to big for cars and upon delivery to the customer, the final payment is received.
To record such transaction, we advised that they use “Customer Payment” window to receive upfront payments and select “Record Deposit” to pay into the account such fund is domiciled.
For Dealers that Offers Car Financing:
QuickBooks lets you record car financing arrangements with clients who are looking to buy new or used cars with an upfront payment and flexible repayment plan, which could span for 6 months, 1 year or more.
You can also use the “Invoice section” to record the car model, the amount receivable (including VAT charges), terms of payment so you can ascertain the ageing status of the clients. The “Receive Payment” lets you post the initial payment and expected recurring payments.
In a situation where it is likely that the amount expected may become recoverable, you can write the receivable against “Bad debt” and if provisions are being made too, you can pass the necessary “Journal Entries“.
For Car Dealers
If your line of the auto business is in buying, keeping inventories and selling cars to the targeted client, you would have entered all the details about the cars you sell, quantity on hand, cost price (shipping fee inclusive) and sales price using the “Item List” window.
Following the guide shared here will no doubt put your books in place without financial management challenge, you will easily generate a profit or loss account, statement of financial position, cash flow, receivable report, VAT liability report, etc at ease.
For a demo on how we can set your car auction brokerage business up in real-time, you can connect with our client support service at info@accountingsoftware.com.ng or call 08105090001.