Recurring payments

I’m new to all of this, so please forgive me if this is a stupid question.

Is it possible to add recurring bills at all? For example, my web hosting is charged monthly and automatically debited from my account.

Usually what happens is that you would import your bank statements on regular basis and then Manager would automatically categorize your payment for web-hosting based on bank rules.

I would like any updated information on setting up recurring payments. I am catching up on a set of books where the bank statements are no longer available to download. Seems I am blocked from this post and am unable to see the content on the link

Recurring sales invoices have been implemented.


Still looking to find out how to do a recurring payable like automatically adding my monthly rent ?

Why not just import your bank statement and categorize all rent payments as expenses as they appear on your bank statement?

Or do you need the system to create recurring purchase invoices? I’m just asking because recurring purchase invoices are a bit unusual way of doing things. Unless I misunderstood something.

Yes looking to add recurring purchase because I’m not importing my banking until 2015.

Why you are not importing until 2015? Are you able to prepare spreadsheet with all transactions at least? Then you can easily import them into Manager in bulk.

Sounds like a good idea. How do you import from a spreadsheet. What template do you use. A search on this subject only revealed that you started working on importing inventory in April 2014.

To import bank transactions from spreadsheet, make sure spreadsheet has following columns:

  • Date
  • Description
  • Amount

You can also optionally have columns:

  • Payee
  • Reference

Then save spreadsheet as CSV file and use Import Bank Statement function to import CSV file under Bank accounts tab.

Hi @lubos
Can we do the same kind importing method for cash accounts?

As I’m using server edition , its taking time to create 15-20 daily expenses in cash account.
It will be easy if I import a spreadsheet as u mentioned above for bank accounts.

Can I create a new bank account named cash1 and transfer my remaining cash from cash accounts to newly created cash1 bank account?
And import spreadsheet with date, description and amount ?

What difference does it makes if I handle cash in cash account or bank account?

Why do we need cash account and bank account if I can manage cash in hand in bank accounts tab?
What is the advantage of having separate cash account tab?

@raj_nann, I’m currently working on improving bank accounts and cash accounts tab. You will see ability to import spreadsheets to cash accounts in upcoming days.

1 Like

Is there a away to record recurring payment against a customer invoice plane for 1st of every month to be added. Actually an installment plane invoice.
Item Unit Price Qty Amount
Laptop 30000 1 30000

Terms of Invoice:
5000 will be paid installment amount every month for up to 6 months.

So in report or invoice we should see due amount 5000 (the installment amount) not the total due of invoice amount.

Always thankful to this abc solution of Manager Development team.

You cannot do what you ask. What you ask would require definition of multiple due dates and amounts.

One way to accomplish something like this in Manager would be to define a recurring sales invoice for a 6-month period, with each invoice being for 5000. The problem with that would be your income would be misrepresented under accrual-based accounting, because the full value of the 30000 sale would not be reflected until the end of the plan.

Unsure how you can invoice1/6th of a laptop each month ?

“Item Unit Price Qty Amount
Laptop 30000 1 30000”

I pointed out the shortcoming of doing so in my post. Please read all the way to the end.

I did the first time hence my comment.

Your highlighted shortcoming is this, “because the full value of the 30000 sale would not be reflected until the end of the plan” - which has absolutely nothing to do with my point.

How does your suggested recurring sales invoice work ?
How do you sell 1/6th of an inventory item each month for six months ?

This has nothing to do with accrual based accounting.

@Brucanna, I am not suggesting this approach. I personally think it is a terrible idea. But @naseerkhattak wanted to invoice for only one-sixth at a time, and this is a method that does what was asked. That does not make it advisable.

You answered your own question with your illustrations. But they look ridiculous, don’t they? That is why I don’t suggest doing it. But from an accounting perspective, it would work: a bad, but functional, solution. This would all be handled much more professionally with a simple note specifying installment payments and dates.

Yes, it does. The full laptop has been sold at the beginning. Therefore, the full amount of income should be reflected. With this one-sixth recurring sales invoice approach, that would not happen, disqualifying the approach. But, under cash-basis accounting (@naseerkhattak did not say which is being used), the income would be properly reflected. In that situation, this terrible idea could be made to work.

So, since we agree this is a bad idea, how about we stop discussing it?

Then someone else is using your profile

No, they never wanted that, but what they did request was:

They ASKED about recurring payments and you responded with advise about recurring sales invoices. Another backfiring red herring.