Forum Discussion

MyAccountsHat's avatar
MyAccountsHat
Experienced Cover User
17 days ago

Custom Invoice Formatting

Hi Everyone 

We're looking to transition our invoicing from a manual excel spreadsheet template to MYOB, but they're quite a complex format, often including multiple billing styles on one invoice, so I'm wondering if it would even be possible?  To give you an idea, a single invoice could include:

 

  1. A lump sum fee for a service 
  2. A part charge of the lump sum fee, for example a 50% deposit of the lump sum 
  3. The full charge of the lump sum fee less the previously invoiced part charge (100% - 50% say)
  4. A percentage fee based on an contract value and the percentage of the work completed to date against the contract: for example 3.4% of $500,000 x 33%
  5. A percentage fee less the previously claimed amount in item 4
  6. Adjustments to the percentage fees when the contract value changes 
  7. Work billed on an hourly rate

The invoice needs also to show:

  1. all the amounts which make up the contract value, which could be multiple items, with the option to have different contract values for different stages of the work. 
  2. The percentage rate each stage of the works is calculated from. 

Is this achievable?  If so where do I start?

 

TIA

3 Replies

  • Isaiah_C's avatar
    Isaiah_C
    MYOB Moderator
    17 days ago

    Hi MyAccountsHat

     

    It sounds like your invoicing setup is quite detailed! Moving from spreadsheets to MYOB is an exciting step, and it’s great to hear you’re exploring ways to streamline things.

     

    The awesome news is MYOB is really flexible and capable of managing a lot. Lump sums, deposits, percentage-based fees, hourly charges, adjustments, you name it! But with all the specific details in your process, it’s a good idea to have a chat with your accountant. They can help fine-tune MYOB to fit your unique needs and ensure everything calculates just right. 

     

    Regards,

    Sai

  • MyAccountsHat's avatar
    MyAccountsHat
    Experienced Cover User
    16 days ago

    Thank you for the reply but this isn't particularly helpful.  I need practical advice regarding how to go about creating my template, e.g. given our multi format billing which base template on MYOB should I choose, not 'speak to my accountant'  They can't assist me with this.

  • Doreen_P's avatar
    Doreen_P
    MYOB Moderator
    16 days ago

    Hi MyAccountsHat,

     

    Multi-format billing with can get tricky, and while this one's a bit outside our usual toolkit, hopefully there's someone in the community here that can help you. If you don't have any success, you might want to check out this link for customising invoices. It has info on what you can change on an invoice. 

     

    Cheers,

    Doreen