I will create an excel order and payment report with formulas

Bulgaria

I speak Bulgarian, English

Excel Cleanup, Reports and PowerPoint Presentations

I turn messy spreadsheets and supplied business content into clear, editable files. My focused services include Excel cleanup for one sheet up to 100 rows and 5 columns, order and payment reports, and...
About this Gig

See order values, payments received and outstanding balances in one editable Excel workbook.


For $30, I will build one order and payment report from your supplied table, up to 50 records and 5 input columns. It includes up to five formula types, repeated down the agreed rows as needed: balance calculations, payment status, order totals, payment totals and outstanding totals.


You receive an editable XLSX with a clear summary, the original data retained, and a short guide to the inputs and formulas. I reconcile totals to your source and test an agreed paid/unpaid example before delivery.


Delivery is 3 days after complete requirements. One revision corrects work within the original brief. Please provide the source, column meanings, currency and payment/status rules.


This is an operational spreadsheet, not accounting or tax advice. Macros, bank connections, multiple currencies, research, major data cleanup and complex financial models are excluded. Personal gallery samples use fictional data.

Platform:

Excel

Development technology:

Excel

Expertise:

Formatting

•

Formulas

•

Functions

•

Dashboard

•

Data validation