Challenges faced :

Bookkeeping Services to a US Food and Beverage Company

Challenges faced :

  • Downloading bank-related information from multiple bank website logins
  • High quantity of outsourcing accounting data received in Google drive with 4 months backlog
  • Multiple data sources to be extracted using numerous login websites for sales, suppliers, and banks from multiple locations
  • A huge pile-up of transactions with the same amount while reconciling bank account in QBO


  • Multiple location bank feeds converted into excel, then in .csv format and finally, uploaded in QBO
  • Passwords managed via the last pass
  • Trained our outsource accounting team to work on the same project and catch up with the backlog on time
  • Internal cut control system for data management and bookkeeping
  • Use the last pass for security
  • Rules creation using online accounting services in QBO to categorize transactions with correct account code

Benefits :

  • Saved time by the creation of effective bookkeeping processes for future goals on time
  • Month-end work shared with clients on a regular basis
  • 100% accuracy achieved while working on accounts outsourcing such as bank transactions in QB
  • Extended contract on outsourced accounting services including additional bookkeeping projects from the same client