I use ModernBill as the accounting package to track domains, packages etc.

I use MYOB for payroll & consulting charges, purchases, etc.

But when you are reconsiling your accounts in MYOB, how do you deal with payments into your accounts, for invoices generated in ModernBill?

As MYOB is not aware of these - so it doesn't line up.

The two ideas I have come up with are:

1) At the end of each month, total up ModernBill invoices totals, and enter this into MYOB as 1 invoice. Then, as each customer pays their invoice, I apply their small portion to the large ModernBill invoice.

2) Get all the ModernBill invoices exported into some kind of file, manipulate the file so that all the invoices are inported into MYOB individually - then I mark the payments off with full amounts against the invoices.

What do you all do?

Seems it wont be that hard to do #2.

You can export your invoice list as a CSV, filtered by date ranges. This can be imported into MYOB.

But I don't see a customers list export anywhere in MB - so might have to do that by hand

Edit: There is an export to Outlook one that might do the trick....

I just want to add that is definitely possible, we have a script that generates a MYOB CSV file each day with all the latest paid invoices. Wasn't too hard to do. Just a matter of getting the correct data all the time.

That's the only issue is that some MB invoices are only HTML and you have to explode all that into an array and just do lots of checking of data and the like. Other invoices have a serialised array in the database that contains all the information you need.

I found that every time you got one particular type of invoice to export correctly, it would mess up another one. You just have to put together LOTS of rules.

Definitely doable, just need patience and a bit of time.

Cheers

Lach

How do you handle assigning customers to an invoice? Or do you just enter them as a cash sale?

We are just completing a module for another program to integrate with MYOB, which has had many interesting "hiccups", especialy when it comes to GST

Do you have the MYOB Developer Kit???

Or Are u just doing it from looking at the program?

As i will be having a MYOB Module for my billing software but unsure as to wether i need to purchase the developer kit or if its doable without

Yes, we have both the MYOB and Quickbooks developers kits / SDK's

QBXML can be a royal pain in the ... well you know the rest of that sentence

Ok Thanks

I'll be having to get the Quickbooks Developer Kit too cos i hope to build a Quickbooks module too

PS. For Anyone thats interested my billing software is on schedule atm and i've just began coding it , BETA Release Date will be early April

You'll have fun with QBXml, it may be XML presae, but does not give you any set schema for the data it returns, which makes things interesting.

If you want a BETA tester, let us know, would love it have a look at your app

We just have them all go into MYOB as cash sales yes.

With the GST we find that some invoices are out by 1 or 2 cents but usually that's not such a problem as the ATO wants GST rounded up anyway.

We wrote ours in PHP and just queried the MB database to get the data and put that data into a CSV file that MYOB can import.

Hi There,

I still haven't gotten this sorted so I'd like to share my thoughts with others using MYOB & MB.

I can do one of two things to get sales into MYOB:

1) Export total sales per month into MYOB as one large sale from customer 'ModernBill'.
2) Export each individual sale (invoice) into MYOB either to the correct customer or to 1 customer 'ModernBill'.



But how do I deal with sales?

I can get the sales out of MB, can can import those to MYOB as:
1) Total sales from the large sale in point 1 above
2) Individual sales from individual customers in point 2 above.

Issues:

Using method 1 - when you are doing a bank rec, you see individual payments in your bank account like cheques, and you have to mark them off a large 'ModernBill' payment

Using method 2 - Sometimes people pay me late. So if they pay for a Jan invoice, in Feb, the import takes the Jan payment off the Febuary sale in MYOB, messing it up.

What do you all do?

Hi everyone.

I currently enter our Modernbill sales straight from the batch total (less any rejected payments) into Receive Money in the Banking section and assign it straight to the income account. This then reconciles with the Merchant Settlements. I bypass the Invoice/Customer Payment side of it in MYOB... it's double entry and unnecessary as all relevent details are recorded in Modernbill. Also, as we report GST (and financial accounts) on a cash basis, it's not necessary to have both MYOB and Modernbill tracking our receivables.

When receiving cheque or eft payments, again... I apply the payment to the relevant invoice in Modernbill, and in MYOB I just enter it as a straight deposit to the income account.

My issue with Modernbill, is now that we have overseas clients, it's a little more messy accounting for the GST Free sales. Now I have to split each batch (where relevant) into GST and GST Free which is where the headache lies.


The easiest way however would be:
Reporting GST on an accruals basis. Generating a monthly revenue report split into tax zones from Modernbill. This I would enter as one invoice per month, and apply all banking/merchant deposits against that invoice. This would reconcile the bankings, and I would reconcile the receivables balance in MYOB with the receivables balance in Modernbill. I wouldn't worry about Jan payments applying in Feb etc.. so long as the Receivables amount reconciles... you have the details of outstanding invoices in Modernbill.

But... this revenue report does not exist!

So until such time as reporting improves from Modernbill.. I am going to continue reconciling my merchant settlements with batch totals, marking off cheque/eft payments in Modernbill... and entering all settlements/bankings as my income in MYOB.

Darlin,

Hmm, I had not thought of putting it through as just money received, that would save tracking it with to invoice numbers, dates, customers, etc.

That's food for thought.

I appreciate your reply.

i'm trying to integrate MB with MYOB as well.. anybody got any pointers or finding? I dont mind paying for the instructs and scripts. =)