K2E Canada Inc
  • Home
  • TRAINING
    • WEBINARS
    • ROAD TO EXCELLENCE ONLINE SEMINAR
    • SEMINARS
    • TECHNOLOGY CONFERENCE
    • INSTRUCTORS
  • NEWSLETTER
    • Signup
  • ABOUT
  • CONTACT
  • BLOG
  • Home
  • TRAINING
    • WEBINARS
    • ROAD TO EXCELLENCE ONLINE SEMINAR
    • SEMINARS
    • TECHNOLOGY CONFERENCE
    • INSTRUCTORS
  • NEWSLETTER
    • Signup
  • ABOUT
  • CONTACT
  • BLOG

Automation of Bills and Receipts - A Followup

7/4/2020

 
In our previous post, we discussed using one of the online automation tools to process your bills and receipts. For many who are not using an online accounting solution, the advantages appeared limited. In this post, we will cover the benefits these tools, like Receipt Bank, bring to any business.

Organization and Filing

The efficiencies gained from these services include:

  • Time previously required to file, archive, and destroy bills and receipts
  • Additional office space made available by the elimination of filing cabinets
  • Quick access to any invoice or receipt
  • Automatic extraction of the vendor, date, invoice number, amount, and taxes to speed up posting
  • Automatic account allocation of expenses

The quick access to any expense document is possible by a search based on the amount, date, supplier, payment method, category, or any combination of these variables.

The need to go to the vendor site, log in, download, and process the invoice is automatic with the tool fetching recurring invoices from a long list of supported vendors. Check out the full listing for Receipt Bank at https://help.receipt-bank.com/hc/en-us/articles/360005754174-List-of-Suppliers-for-Invoice-Fetch

Transaction Summary

Now that you have all of your invoices and receipts automatically saved and the data extracted, you can export the critical information. Using Receipt Bank as an example, filter the list of documents in the archive and select the receipts and invoices to export. 
Picture
Figure 1 - Select Items to Export

Now click export, select the format from the drop-down list, and click Generate.
Picture
Figure 2 - Select CSV Format from the drop-down list

Export your items using the various options to find the CSV format that works best for you. For this example, we used the Receipt Bank Default.

Save the exported CSV file in a folder with the other exports from previous days, weeks or months.

Summarizing with Excel

With all the export files in a single folder, you can now use Excel’s get data from folder feature to combine the results into a single table or pivot table.

Get Data from Folder is found in the data ribbon under Get Data > From File > From Folder. The panel that opens requires you to complete the folder path.
Picture
Figure 3 - Get Data Folder

With the folder path completed, click OK and the list of files will be displayed, now click combine.
Picture
Figure 4 - Review the list and click Combine & Load

The next screen provides a sample from the First File, click OK. The data is now in a single table in Excel.
Picture
Figure 5 - Combined Data

With the next export file added to the folder, a right-click on the table and selecting refresh will cause Excel to rerun the query and update the table to include the new data.

A summary of the receipts using the sumifs function or a pivot table can be the basis of your accounting entry. 
Picture
Figure 6 - Summary of Expenses

Export the receipts to a PDF as a backup for the entry.

Summary

It is time to look at automation to extract data from your receipts and bills. Whether you connect to online accounting, export and summarize for posting or post each entry in your accounting system manually, the time savings are significant.

To try Receipt Bank free for 30 days go to Receipt Bank to sign up. Other options include Auto Entry and HubDoc .

Ward Blatch, CPA CA


Comments are closed.

    Categories

    All
    2022
    Accountant
    Accounting Software
    Accounting Solutions
    Adobe
    Advisory
    AI
    Artificial Intelligence
    Automation
    Backup
    Bitcoin
    Blockchain
    Business Automation
    Business Continuity
    Business Intelligence
    Business Management
    Cloud Computing
    Collaborate
    Collaboration
    Colonial
    Computer
    COVID 19
    COVID-19
    CPA
    CRM
    Cryptocurrency
    Customer Relationship Management
    Cybersecurity
    Cyptocurrencies
    Dext
    Doc.It
    Ecommerce
    Emerging Technologies
    Entrepreneurs
    Excel
    Forecasting
    Forecast Sheet
    Google
    Grammarly
    HR
    Internal Controls
    Internal Priorities
    KPIs
    LET
    Links
    Management Reports
    Microsoft 365
    Microsoft Office 2021
    Microsoft Teams
    Office
    Office 365
    Online Shop
    Outsourcing
    Pandemic
    Paperless
    Personal Computer
    PivotTables
    Power Automate
    Power BI
    PowerPoint
    Productivity
    QuickBooks
    Quickbooks Online
    Ransomware
    Receipt Bank
    Remote Work
    RPA
    Sage 50
    Security
    Small Business
    Small Business Accounting
    Small Business Accounting Software
    Stockhistory
    Technologies
    Technology
    Tech Update
    Windows
    Windows 10
    Windows 11
    Word
    Work At Home
    Workflow
    Work From Home
    Xcm
    Zoho
    Zoho CRM

    Authors


    Ward Blatch
    Ward provides consulting and training services as the Managing Director of K2E Canada Inc. He joined K2E Canada in 2005 and is responsible for the Canadian operations of this international consulting group, which provides professional development technology education for accountants across Canada and the US. Ward lives in rural Nova Scotia and can be reached at ward@k2e.ca.

    Tommy Stephens
    Tommy is one of the shareholders in K2 Enterprises, affiliating with the Firm in 2003 and joining as a shareholder in 2017. At K2, Tommy focuses on creating and delivering content and is responsible for many of the Firm's management and marketing functions. Tommy resides in the metro Atlanta area. You may reach him at tommy@k2e.com.

    Randy Johnson
    Randy is a nationally recognized educator, consultant, and writer with over 40 years experience in Strategic Technology Planning, Accounting Software Selection, Paperless, Systems and Network Integration, Business Continuity and Disaster Recovery Planning, Business Development and Management, Process Engineering and outsourced managed services. Randy can be reached at randy@k2e.com


    Bernie Smith
    Bernie coaches businesses to develop meaningful KPIs and present their management information in the clearest possible way to support good decision making. As the owner of Made to Measure KPIs, he has worked with major organisations including HSBC, Airbus, UBS, Barclays, Credit Suisse, Lloyds and many more.

    RSS Feed

Training & Education

Webinars
Road to Excellence Online Seminar
Seminars
Conferences
Instructors

Tech News

K2E Canada's Tech Update Newsletter

More

Privacy Policy
About
Contact

K2E Canada Inc.  |  484 Scarlett Crescent  |  Burlington, ON L7L 5M2  |  (902) 200-9207
© 2022 K2E Canada Inc. ALL RIGHTS RESERVED.