poocr-vatinvoice2excel

What This Skill Does

The poocr-vatinvoice2excel skill is a professional-grade automation tool designed to streamline the extraction of data from VAT invoices. Powered by the poocr library and Tencent Cloud's AI OCR capabilities, this skill allows users to convert image-based invoices (PDF, JPG, PNG) into structured, readable Excel files. It supports both individual file processing and batch operations, making it an essential utility for organizations handling large volumes of financial documentation. By automating the extraction of key fields such as invoice numbers, dates, tax amounts, and totals, it eliminates manual entry errors and significantly improves productivity.

Installation

To integrate this skill into your OpenClaw environment, execute the following command in your terminal:

clawhub install openclaw/skills/skills/coderwanfeng/poocr-vatinvoice2excel

Before running the skill, ensure you have obtained your Tencent Cloud SecretId and SecretKey from the official Tencent Cloud console. These credentials are required for the underlying AI to process and interpret the invoice content accurately.

Use Cases

This skill is highly effective in several professional domains:

• Corporate Finance: Automating the collation of employee expense receipts for reimbursement cycles.
• Tax Compliance: Rapidly aggregating VAT invoice data for quarterly or annual reporting and audit preparations.
• Logistics & Procurement: Digitizing supplier invoices for integration into ERP or accounting systems.
• General Data Entry: Converting massive batches of scanned paper invoices into searchable spreadsheet records, saving hours of manual labor.

Example Prompts

1. "Please process all the VAT invoices located in my /documents/invoices folder and save the result as an Excel file in the output directory."
2. "I have a PDF invoice here. Use the poocr-vatinvoice2excel skill to extract the total amount and tax details into a new Excel sheet."
3. "Batch identify the invoice images in the uploads folder using my Tencent Cloud credentials and export the data to the report folder."

Tips & Limitations

To maximize the performance of this skill, ensure the uploaded files are clear, high-resolution scans. Low-quality images or images with heavy background noise may lead to lower OCR accuracy. Additionally, verify that your Tencent Cloud account has sufficient API quota to support the batch processing load. Note that this skill primarily supports standard VAT formats; unconventional or custom-made invoice templates may require manual verification after extraction. Always ensure that your API credentials are kept secure and are not hardcoded in publicly accessible scripts.