Separate invoices by category
- Overview:
One of our partners is a leading global law firm that deals with a large volume of invoices from suppliers and issues invoices to clients. However, manually sorting invoices into input/output categories for accounting purposes was a time-consuming and error-prone process. To address this challenge, our team developed a solution to automate this process using Power Automate, a cloud-based service that enables the creation of automated workflows between apps and services.
2. The solution:
Our team developed a solution to automate the separation of invoices into input/output categories using Power Automate. The solution included the following steps:
- The user logs onto their company bank account, runs the automation, it downloads the bank statement and separates all invoices based on which segment of the company the invoices are for.
- Based on the supplier/customer’s name, the flow determines whether the invoice is a client or supplier invoice and sorts it accordingly.
- Finally, the flow organizes all invoices in their corresponding folders on the system.
3. The results:
Our team developed a solution to automate the separation of invoices into input/output categories using Power Automate. The solution included the following steps:
- The user logs onto their company bank account, runs the automation, it downloads the bank statement and separates all invoices based on which segment of the company the invoices are for.
- Based on the supplier/customer’s name, the flow determines whether the invoice is a client or supplier invoice and sorts it accordingly.
- Finally, the flow organizes all invoices in their corresponding folders on the system.
Entering invoices in SAGA C and SAGA P.S.
- Overview:
Legal departments struggle with the manual entry of invoices into their accounting software. The manual data entry process was time-consuming and often led to delays and inaccuracies in accounting records. To address this challenge, one of the largest attorneys network partnered with our team to automate their invoice data entry process using Power Automate.
2. The solution:
Our solution involved using Power Automate to extract invoice data from email attachments and input it directly into the ERP and Accounting systems. The process involved the following steps:
- The invoices processed by the invoice robot are stored in a specific location on the system.
- Power Automate automatically reads the invoice and extracts the necessary data.
- The extracted data is then used to create a new entry.
- The entry is automatically updated with the invoice data, including vendor information, purchase order number, invoice number, and amount.
This solution was customizable and flexible to accommodate different invoice formats and business rules. It was also scalable to handle an increasing volume of invoices.
3. The results:
- The solution eliminated errors and improved the accuracy of invoice data entry.
- The process reduced the risk of duplicate entries and ensured the consistency of accounting records.
- Integration with the ERP and Accounting systems eliminated the need for manual data transfer, resulting in streamlined workflows and improved productivity.
- Overall, the solution improved the efficiency and effectiveness of our partner’s accounting department, resulting in significant time and cost savings.
Automating the extraction of bank statements from 2 different banks
- Overview:
Our partner, a global law firm, needed a solution to automate the process of extracting bank statements from two different banks. This task was time-consuming, and the company required a more efficient and accurate approach. BeeDigital has developed a solution using Power Automate to automate the extraction process for the two banks.
2. The solution:
Our team developed a Power Automate solution that automatically extracts bank statements from the two banks, using their APIs. The solution was designed to run daily and extract statements from the previous working day.
- The process begins with the Power Automate flow being triggered manually after the user logs on to their company bank account using their physical token.
- The flow then uses the banks’ web platform and downloads the bank statements.
- The extracted statements are then saved in a designated folder on the system.
The solution was customized to meet the specific requirements of our partners, including the formatting and content of the bank statements, and the frequency of extraction.
3. The results:
- Our solution has provided partners with a fast, accurate, and reliable method of extracting bank statements.
- By automating this process, the firm has been able to reduce the time and effort required for this task.
- Additionally, the solution has provided greater visibility into the firm’s financial transactions, allowing for better financial analysis and decision-making.