Bulk Invoices Set Up

RENAE HUTCHESON
RENAE HUTCHESON Member Posts: 2
edited June 2020 in Accounts Hosted
Using Reckon Accounts Hosted. Bulk invoices - 'similar' item.  Client wants to send out annual membership fees (700+) and trying of easier way than input each one manually.

Below is example of template:

Membership Fee 2020/2021       0.00
Club Support Voucher                 0.00
Non-Participation Levy                0.00
Hardstand One                            0.00
Hardstand Two                            0.00
 
Would like to have this template for each invoice and then adjust accordingly.

Thanks in advance :)
Renae

Comments

  • PhuongDo
    PhuongDo Reckon Developer Partner Posts: 314 ✭✭✭
    edited June 2020
    Hi Renae, I can create a quick tool that run through a list of your member customers (can be a text file or any format) or directly from Reckon (with a field or flag to indicate it is a membership). The app the will create n invoices for these customers with all the items that you want prefilled. Then you can go thru the invoice to adjust accordingly. Let me know if it makes sense. My email is phuong@cactussoftware.com.au Thanks, Phuong


    Phuong Do / Reckon Developer Partner

    phuong@cactussoftware.com.au


  • cosmic
    cosmic Reckon Developer Partner Posts: 1,073 ✭✭✭
    edited June 2020
    Renae
    Are you looking a 3rd party tool
    Or like to use iif excel feature?
    This option is fiddly but your cost is minimal to create a 3rd party tool the cost bit higher than above option
    Cosmic is offering free for business especially in processing sales or bills 500 bills or invoices
    We are Accountants and developers for very long time for Reckon
    Call me on 0407068942

    Cosmic Accounting Group

    Accountants and Tax Agents 22397009

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited June 2020

    Hi Renae

     

    You can either:

     

    • Setup & use a “Group” Item or
    • Memorise an existing Invoice as a “template” that can be regenerated at any time for any client

     (or both)  :)

     

    A Group Item is a single “Item” containing multiple Items from your Item List.  Instead of entering each of the 5 Items in your example, you would create one “Group” Item with each of these in it.  You then just enter the Group Item on the Invoice & the 5 Items we prefill.

     

    To create/re-use an Invoice “template”, simply open a previously-entered one, then click on Edit (along top toolbar) then on Memorise Tax Invoice in the dropdown menu.

     

    Memorising Transactions for auto-entry is a great timesaver in other scenarios too eg Bank Fees, Interest, Loan Repayments etc – for any regular/systematic payment paid or received.

    You can choose to have the system enter it on a specified time frequency &/or on a particular day, ongoing or for a set number of times.

     

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    0422 886 003

    shazinoz2@bigpond.com

    www.accounted4bs.com


    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • PhuongDo
    PhuongDo Reckon Developer Partner Posts: 314 ✭✭✭
    edited June 2020
    Hi Renae,

    If you still need some helps for this problem. I can explain a bit clearer of what the tool can help you. Basically, you can set up an excel file looks similar to the one below:



    You can have more or less item, and your list of customer/member can go on (the list can be exported from Reckon).

    It will be very easy for you to go through and set up the price for each customer and then have the app to read this file and import into Reckon as invoices. And you don't have to do anything further, all set!

    I hope it makes sense.

    Thanks,

    Phuong


    Phuong Do / Reckon Developer Partner

    phuong@cactussoftware.com.au


  • RENAE HUTCHESON
    RENAE HUTCHESON Member Posts: 2
    edited June 2020
    Thanks Phuong - looks great! I am meeting with Club late tomorrow afternoon and will discuss.  How do I get hold of you direct?
  • PhuongDo
    PhuongDo Reckon Developer Partner Posts: 314 ✭✭✭
    edited June 2020
    My phone number is O4 3one 863 49 eight. Thanks.


    Phuong Do / Reckon Developer Partner

    phuong@cactussoftware.com.au