Loading...

Financial Transaction Excel Consolidation

  • Posted 2 weeks ago
  • Partially remote

Job description

I have several Excel files that hold our financial records, each one split out by transaction type. Right now, only the sales transactions need to be brought together, cleaned up and presented in one master workbook that I can trust.

Here is what I need from you:

  • Merge every sales-related sheet and file into a single, well-structured master sheet. 
  • Remove duplicates, fix inconsistent date or currency formats and flag any obvious data gaps so I can trace them quickly.
  • Add a simple dashboard or pivot table summary showing total sales, averages and a monthly trend line so I can spot patterns at a glance.

Projects you may like

Fixed price project

N$900.00-N$1,500.00

I have a PDF document that I need converted into an editable Word file for ongoing editing and revision work. The look and feel of the original must stay intact, so every margin, font style, line break, and layout nuance should carry over seamlessly to the .docx version. While converting, please…

  • Remote
  • Senior level
  • 1 freelancer
Fixed price project

N$2,000.00-N$4,000.00

I have a collection of handwritten notes that must be re-typed accurately into a clean Microsoft Word document. This is strictly text data entry, no numeric tables or transcription from audio, so strong typing skills and great attention to spelling, punctuation, and overall formatting are essentialThe job is straightforward: read each…

  • Remote
  • Senior level
  • 2 freelancers