07/11/2023 Franck Bugnet How to

How to program and generate recurring purchases

What could be more tedious and time-consuming than having to enter the same expenses in your accounting every month or quarter, such as hosting fees, subscriptions to various tools like Semrush or MailChimp, bank charges etc.

For as long as I can remember, AutoPresta, PrestaShop's complete yet simple accounting solution for micro-businesses, lets you store this type of purchase as templates and reuse them to insert new pre-filled expense lines.

Version 3.0 goes much further in automation, offering a true recurring purchase planner.


Creating a new recurring purchase from an existing one


Let's take an example to illustrate the process. In your current accounting, in AutoPresta's expense register, let's imagine that you've already entered this purchase once corresponds to the monthly billing of your hosting company (line selected and click on the edit button to see the details):

Expense to plan


You know that this expense will recur every month and would like to avoid having to re-enter everything by hand. So we'll use this line as a template to create a recurring purchase.

  1. Select the line.
  2. Click on the "Periodicals"
  3. button.
  4. The Planned or Periodical Purchases window opens. The table lists planned purchases already scheduled. Click on the "New planned purchase from selected purchase..."
  5. button.


The planned purchase table

This opens the planned purchase editing window, pre-filled with data from the pre-selected purchase. All that remains is to give it a name and define the periodicity:


Editing a planned purchase

Periodicity selection and settings



None


This allows you to create a purchase template, which will not generate periodic purchase lines automatically, but only manually, on the date of your choice.

Daily


For purchases, expenses or billings that take place every day of the year, such as parking tickets or freeway tolls to get to work, for those who work even on weekends.

X times a week


Give you more precision by allowing you to choose the days of the week concerned.


Recurrence x times a week

Monthly


For purchases with a monthly frequency or more. You can indicate the number of the day of the month or the calendar day as here the second Tuesday of each month:


Monthly recurrence

X times per year


For billings or purchases occurring several times each year. Typically this may be the case for quarterly payment of certain charges.
You have the option of indicating the months of the year concerned, and as for monthly payments, to indicate the date or day:


Multi annual or quarterly payments


Add or update method


When generating purchase lines, the case may arise that the same occurrence of the same purchase has already been generated, in the register.
This option lets you define what autoPresta should do in this case Either replace the line, or keep the existing line intact (so do nothing), or add a new line (it's up to you to delete any duplicates afterwards).


Update or add

Automatic payment date


When automatically adding new occurrences to the register, of the planned purchase, you have various choices regarding the automatic filling in of the purchase payment date.

  • Or leave it empty
  • Or fill the payment date with the purchase date
  • .
  • Or fill it with the date of the day the purchase is added to the register
  • Or calculate this date with an interval of days after the purchase date. The interval is the difference between the two dates A and B.


Automatic payment date

Creating a recurring expense from scratch


You don't actually have to already have an occurrence of a purchase in the register to create a planned purchase. It can be done from a blank form.

  1. Without selecting an expense line (not annoying though if there's one selected), click on "Periodicals"
  2. In the planned purchases management window, click on "New blank planned purchase"
  3. The form opens, give your plan a name, a recurrence, enter descriptions and amounts and save. The window closes and your planned purchase is added to the list.


New blank recurring expense

How to generate automatic occurrences of planned purchases


In fact, once a planned purchase has been created, it is present in the planned purchases table, but nothing has been added to the expenditure register or purchase register. To fill the register, you need to request the generation of occurrences.

An occurrence is a new purchase line, at a given date, created from the templates that are the planned purchases.

You can either generate series of occurrences thanks to their periodicity, or manually add them one by one, at a precise date.


To generate hit series:

  1. Open the window listing planned purchases.
  2. Only planned purchases defined as active will be used by the generation tool. Other lines will be ignored.
  3. Similarly, only those with a recurrence will give rise to a series. Other lines will be ignored.
  4. Define the start date of the series to be produced (sets itself on the date of the previous generation).
  5. And the end date (sets itself to the current date).
  6. Click on the hit series generation button.
  7. All requested hits are automatically generated and inserted (or replaced, ignored... depending on the setting in the "If already generated" column) in the purchase register.



Generating periodic purchases


To manually add a single occurrence of various planned purchases, on a specific date:

  1. As before, start by opening the recurring purchases window.
  2. But this time select the lines of the planned purchases, for which you wish to generate a new occurrence.
  3. Choose the purchase date.
  4. Click on the button "Add an occurrence of the selected planned purchases, on the date of:"
  5. The purchase lines (one per planned purchase) are added (or replaced, ignored... depending on the setting in the "If already generated" column), in the expenditure register, on the requested date.



Manual addition of individual hits


Category's other articles Managing your PrestaShop accounting

Settings
  • Login
    • £ GBP
    • $ USD
Menu