Our client United Noodles, the largest Asian grocery store in Minnesota and its bordering states, faced the monthly burden of a long-standing tedious Accounts Payable (AP) process. The market bought the majority of its products from its vendor, Spartan Nash, which had around 30 invoices per electronic (ACH) transaction.
Each invoice had numerous categories for each account (e.g. Dairy, General Grocery, Administrative, etc.). This required our client’s controller to spend numerous hours each week renaming all invoices and sorting them into their appropriate category.
Need to clean up your Quickbooks file,affordably?
With simple automations and an organized method,we set out with ha goal of reducing the workload for this weekly project by more than 70%.
Taking a look at our client’s statements, we realized we needed to convert the statements provided by Spartan Nash into a format that could be uploaded and read by Quickbooks Online (“QBO”).
Once we accomplished this, we eliminated the requirement for a human to transfer the data into the appropriate portions of QBO.
We next recognized that each bill number needed to be unique so it could be distinguished within QBO. The Bandicoot team created a simple solution to accomplish this: add an “A,” “B,” “C,” etc. to the end of any invoice with a similar invoice number, creating unique bill numbers that did not repeat.
Bandicoot also converted the accounts in Spartan Nash’s bills to accounts used by our client. Finally, we added the sum of the invoices, which equaled the amount of the electronic transaction, to the memo for easier processing.
As a result of our simple but creative solutions, United Noodles’s controller reduced the time she needed to spend on AP from multiple hours per week down to approximately 15 minutes per week. This freed up countless hours in our client’s bookkeeping process, allowing them to just focus on their business. Bandicoot’s expert team of accountants and bookkeepers can do the same for you. It is a creative process that we enjoy, tailored to your unique needs.