Sage 50 Payables Data Import
Budget: $25 – $50 USD
I need the payable and billable data that currently lives in several Excel spreadsheets moved into Sage 50. The task centres on importing data only—no customer, inventory, or other modules—so accuracy on vendor IDs, invoice numbers, dates, amounts, and account allocations is critical.
You’ll map the spreadsheet columns to the correct Sage 50 fields, clean up any obvious inconsistencies, run a test import in a duplicated company file to confirm balances, and then complete the live import once we both agree the numbers tie out. Your tool of choice is flexible: Sage 50’s Import/Export wizard, ODBC scripts, or a third-party utility are all fine as long as the end result is clean and free of duplicates.
Deliverables
• Reusable field-mapping template for future imports
• Test import with proof (screenshots or short screencast) that totals reconcile
• Final live import and a brief summary report of what was brought in
If error logs appear, please resolve them or flag the corrections I need to make in the source sheet. This is a one-off job for now, though smooth work here could lead to additional Sage 50 reporting tasks later.
You’ll map the spreadsheet columns to the correct Sage 50 fields, clean up any obvious inconsistencies, run a test import in a duplicated company file to confirm balances, and then complete the live import once we both agree the numbers tie out. Your tool of choice is flexible: Sage 50’s Import/Export wizard, ODBC scripts, or a third-party utility are all fine as long as the end result is clean and free of duplicates.
Deliverables
• Reusable field-mapping template for future imports
• Test import with proof (screenshots or short screencast) that totals reconcile
• Final live import and a brief summary report of what was brought in
If error logs appear, please resolve them or flag the corrections I need to make in the source sheet. This is a one-off job for now, though smooth work here could lead to additional Sage 50 reporting tasks later.
Related categories:
Visual Basic
Data Processing
Data Entry
Accounting
Excel
Import/Export
Database Management
Data Management