Cherry launches from stealth to automate accounting
Cherry is a new FinTech startup launched out of stealth that aims to automate accounting and transaction processes.
Accounts Payable Automation with AvidXchange
Hear from Rent Manager customers about their experience with the integration between Rent Manager and AvidXchange, our Preferred Partner specializing in Accounts Payable Automation.
AvidXchange is a web-based vendor bill and payment solution that is fully integrated with Rent Manager, enabling you to reduce paper, time, and the costs associated with processing bills and printing checks. Gain 100% visibility into your AP process with automated approval workflows, while maintaining tight accounting controls.
Learn More: https://info.rentmanager.com/request-information-from-avidxchange
——————————————————————————————————————————————————-
SUBSCRIBE TO OUR PODCAST ON YOUR PREFERRED PLATFORM:
https://www.rentmanager.com/podcast/
SOCIAL MEDIA:
LinkedIn: https://www.linkedin.com/showcase/rentmanager/
Facebook: https://www.facebook.com/RentManager
Instagram: https://www.instagram.com/rentmanager/
Twitter: https://twitter.com/RentManager
EMAIL:
[email protected]
Advanced Excel in Microsoft Power Automate Desktop – Use Case for Accountants
This advanced use case shows how to work with Excel in Microsoft Power Automate Desktop. We’re solving an RPA process for accountants, where we want to extract web data to Excel and automate and manipulate it in Excel.
�� Download the course materials: https://andersjensen.org/microsoft-power-automate-desktop/use-cases/excel-and-accounting
VIDEOS FOR YOU:
�� Save Web Data to Excel – Power Automate Desktop Advanced Use Case: https://youtu.be/7R5EjshDoQU
�� Power Automate Desktop For Beginners (4.5+ hours): https://youtu.be/HUq6ZQhOpbk
POWER AUTOMATE DESKTOP GROUPS:
�������� Discord: https://discord.gg/iloveautomation
– Join my network with 4000+ Automation/RPA developers, where we solve Automation/RPA problems, network and help each other upgrade our careers. It’s free!
������ LinkedIn: https://www.linkedin.com/groups/12566435
������ Facebook: https://www.facebook.com/groups/754059285247921
FOLLOW ME:
�� LinkedIn: https://www.linkedin.com/in/andersjensenorg
�� Instagram: https://www.instagram.com/andersjensenorg
�� Facebook: https://www.facebook.com/andersjensenorg
�� Twitter: https://twitter.com/andersjensenorg
�� Email Newsletter: https://andersjensen.org/email-newsletter
0:00:00 Intro
In today’s Microsoft Power Automate Desktop lesson, we solved an advanced Excel use case.
0:00:55 Extract Web Data to Excel
Download the course data to a desktop folder. Save the path because we’ll use it in Power Automate Desktop as a variable. This is best practice, as we can use the variable in multiple actions, and it will be easy if we move the project and need to change the path. Use a Launch Excel action to open an Excel instance and a Close Excel action to save and close it again. The Set active Excel worksheet action is used to ensure we use the correct sheet. Read the Excel data into a DataTable. For each row in the DataTable, we want to do an internet search based on the values in a column, extract the web data and save it to DataTable and then Excel. The data we want to save is currency data from the Danish National Bank. Using the Extract data from web page action lets us automatically extract the currency data into a variable. Then, we can write the data to the Excel sheet with a Write to Excel worksheet.
25:21 Using Subflows
It’s best practice to use subflows in Power Automate Desktop. We do it to keep our projects organized.
29:40 Advanced Excel Accounting
This part teaches you a lot of advanced Excel in Power Automate Desktop. We’ll practice DataTable work, referencing, lookups, and manipulating data for each row of Excel sheets/tables. It targets accountants, but everyone can learn much from the use case. When you want to do calculations on Excel data, remember to convert the data to numbers, even though it looks like numbers, e.g., a Convert text to number action.
47:46 Four Eyes Check
Based on the values in the Excel sheet, our Power Automate Desktop process will send email warnings to the compliance department if the values are significant – a four eyes check. Send an Outlook email message with the Send email message through Outlook action.
52:52 Error Handling
We can make very advanced error handling in Microsoft PAD. For example, here, we check for a blank value, meaning we can’t do a calculation.
#powerautomate #powerplatform #office365
Accounting Automation: how much money we saved and how?
How much money can be saved when automating accounting? This question was answered in a five-month study at much. GmbH in collaboration with the Chair of Financial Accounting of the TU Munich School of Management. Even though the findings are based on four companies using the German Accounting Standard (HBG), the insights are directly transferable to any country and company.
This talk is for strategists wishing to quantify and benchmark automation savings, process optimizers looking for the next step and Odoo partners that want to implement advanced processes for their customers. The talk will present the most important findings of our study (including cost savings figures), blue prints to automate accounting processes and lastly will give insight on how to do this with Odoo. After this talk, you will know the basic processes in accounting and how to optimize them. You will gain an understanding of the needed tools and how to bring them together in Odoo Enterprise. Furthermore, you will have the figures and arguments to convince management and clients to automate their accounting processes.
Will Accountants Be Replaced By Machines? Accounting Automation Episode #1: Bank Reconciliations
Many of you have been asking me to talk about automation and its effect on the Accounting profession. Today is episode #1: The automation of Bank Reconciliation
My Best-Selling Products:
Get My “Night Before the Accounting Interview Guide” including All Levels Q &A:
https://thefincontroller.com/p/the-night-before-your-accounting-interview-guide-for-all-levels
�� Get $25 off MY ONLINE COURSE ON FINANCIAL METRICS
https://thefincontroller.com/p/learn-financial-metrics-kpis/?product_id=2659754 &coupon_code=SAVE25 &preview=logged_out
Products I love:
⚪️ �� Roger CPA Review Course (get 50% off): https://www.uworld.com/productreferral.aspx?ukey=8lzsxx2bT8qzYRxekeTKyWQ3d3d
⚪️ �� Learning//SkillShare (get 2 weeks free): https://www.skillshare.com/r/profile/Bill-Hanna/7521537
My Recommended Finance & Accounting Books ��+��=��
⚪️ Auditing: https://amzn.to/361wJhZ
⚪️ Forensic Accounting: https://amzn.to/2G6t9bo
⚪️ Introduction to Finance: https://amzn.to/2ExgUEA
⚪️ Introduction to Managerial Accounting: https://amzn.to/33SEyE4
———————————————————————
Hang Out with me on social media:
��https://www.tiktok.com/@thefinancialcontroller
����♂️https://www.facebook.com/groups/780732429036886/?source_id=101273467885666
�� https://www.instagram.com/the_financial_controller/
DISCLAIMER: Links included in this description might be affiliate links. If you happen to purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel so I can continue to provide you with free content each week!
All views expressed on my channel are mine alone. Not intended as financial or professional advice.