a
andrewjcollis

Andrew C

@andrewjcollis
5.0(9)

Excel Dashboards, Budgets and Financial Models I Hospitality

Australia
English
About me
I own and run a restaurant in Sydney. Every dashboard, budget and cost model I sell here, I built for myself first — because I needed it on a Monday morning, not because it looked good in a portfolio. Now I build them for other operators and small businesses: Excel and Google Sheets dashboards, budgets and cash flow forecasts, cost and margin analysis, financial models, VBA automation, and Word templates that don't fall apart. Every file is unlocked, documented and yours to edit. No black boxes, no jargon. Tell me the decision you're trying to make and I'll tell you what you need.... Read more

Skills

a
andrewjcollis
Andrew C
Offline • 
Average response time: 1 hour

See my services

Formulas & Macros
I will build excel vba macros and automation to save you hours of manual work
5.0(1)
Data Dashboards
I will clean your data build an excel dashboard and write the report

Portfolio

Work experience

TokyoTaco®

Owner I Operator

TokyoTaco®

Dec 2021 - Present4 yrs 9 mos

I co-founded and run a Japanese-Mexican fusion restaurant, and I own the P&L end to end — weekly labour and food cost, menu margin by dish, cash flow, supplier pricing and promotion performance. Every model the business runs on, I built: recipe costing down to ingredient level, a weekly labour dashboard fed automatically from our rostering system, a 13-week cash flow, and a budget vs actual pack I review every Monday. This is why my spreadsheets are built the way they are. I have to use them at 6am on a Saturday, not present them.

Accor

Restaurant Manager

Accor

Mar 2017 - Mar 20214 yrs

Hotel food and beverage across restaurant, bar, banquets and events. Forecast covers and revenue against occupancy, costed function and event packages, and reconciled event P&Ls after the fact. Hotel finance is where I learned budgeting discipline properly: driver-based forecasts, month-end variance analysis, and having to defend a number to a financial controller who has already read the file. It is the reason I build models with a checks tab and no hardcoded numbers.

9 Reviews
5.0

(9)
(0)
(0)
(0)
(0)
Rating Breakdown
  • Seller communication level
    5
  • Quality of delivery
    5
  • Value of delivery
    5
1-5 out of 9 Reviews
Sort By
Most relevant
    S
    image-docs

    sherley_jiang

    CN

    China

    Ongoing collaboration
    5

    Very glad to work with Andrew again, he followed all the instructions and deliver it with a fast time, the recording are also perfect, we'de love to work with him again for more projects! Thanks again!

    $50

    Price

    2 days

    Duration

    gig

    Formulas & Macros

    Helpful?
    Yes
    No
    D
    image-docs

    dougfogg

    AU

    Australia

    Ongoing collaboration
    5

    On Time & to budget

    $50

    Price

    10 days

    Duration

    Helpful?
    Yes
    No
    H
    image-docs

    hairyasbeards

    AU

    Australia

    5

    Andrew was great communication throughout and worked with me through clarifying the details. Highly recommend

    $50-$100

    Price

    3 weeks

    Duration

    Helpful?
    Yes
    No
    S

    saramonroe451

    US

    United States

    5

    Highly IMPRESSIVE! Andrew C's exceptional attention to detail and professionalism truly exceeded my expectations in data processing. Not only did he deliver superb quality work, but his quick responsiveness and language fluency made the collaboration a breeze. 🙌

    $50-$100

    Price

    2 days

    Duration

    Helpful?
    Yes
    No
    S
    image-docs

    sherley_jiang

    CN

    China

    Ongoing collaboration
    5

    Very happy to work with Andrew,pay highly attention to our instruction and fast delivery,we'd like to work with him again with more project. Many thanks for your support again!

    $50-$100

    Price

    8 days

    Duration

    Helpful?
    Yes
    No