We had a meeting with one of our new clients who runs an established business in the hospitality industry here in Lagos, they needed an accounting software that will track all sales transactions on room booking, and bar sales at the back end office. Although, they already have a hotel management software for front-end sales, the major accounting features required to get necessary financial reports available were still missing out. So, ultimately, you would expect that the only solution is to import all daily sales transactions from the hotel software into QuickBooks which was our recommended path. But here is the challenge, the CFO also wanted all their past transactions in the last three (3) to be keyed into the accounting software so that they won’t miss out some transactions for reference purposes, here are what we did:
- We designed an IIF excel spreadsheet that will import all sales transactions into QuickBooks
An IIF excel file is QuickBooks’ recommended spreadsheet format for importing bulk transactions, which could run for 5-10 years, by mapping each account heads and types into their necessary chart of accounts so that when each account head is imported, they are rightly reported in their financials. For instance, when we imported sales transactions, we expected the income heads and their corresponding accounts which could be cash or receivables, depending on whether cash was paid or not, to be displayed in the profit or loss account.
- We downloaded the bank statement for the past years & imported into QuickBooks
While the IIF file handles the sales side of the prior year’s transactions, the bank statement shows all the payment made by their customers via direct transfer or POS and the expenses incurred so far, so it’s expected that by the time we import all banking transactions, they should have their prior year’s transactions in QuickBooks and when anyone reviews it, it would look like they have been using QuickBooks since inception.
I have already shared a guide on how we imported payments from school management portal into QuickBooks – This is not different from what we deployed in the hotel except that we added a new column that tracks expenses (cheque/withdrawal).
Like I said in that post, integration of third-party applications with QuickBooks is seamless on the latest version of at most 2-3 years. So, if you are still using an outdated version, you might need to upgrade before we implement.
While these tips can help hotel get started faster, it is still adapted to businesses in other industries. If you have prior years’ transactions in excel and looking for a solution that will help you push them into an accounting software, feel free to contact our support department, send a mail to info@accountingsoftware.com.ng or call 08105090001