Any way to import customer payments??

Discussion in 'Microsoft Accounting' started by groov, May 6, 2010.

  1. groov

    groov Guest

    Hi there,

    We're dealing with hundreds of customer payments a week, having to do each
    one by one is very very slow.

    Does anyone have a way of importing these payments into MOA 2009? I#m happy
    to buy in software if anyone has done this.

    Basically we get lots of payments from Paypal and from Sagepay. All I want
    to be able to do is is say to MOA

    Import Payments like this CSV file or similar.

    Invoice number, amount, payment type, nominal code to pay into, reference

    And it should mark the invoice as paid

    Help!

    Thanks

    Groovico
     
    groov, May 6, 2010
    #1
    1. Advertisements

  2. groov

    icreateofx Guest

    groov - you can convert your paypal csv download to ofx and then import the
    ofx using iCreateOFX Basic.
    The resulting OFX will have the PayPal transaction charges included too.
    Download it from : http://icreateofx.co.uk/Convert-CSV-to-OFX

    As for Sagepay, you can submit the file layout to have a script written for
    it.
     
    icreateofx, May 7, 2010
    #2
    1. Advertisements

  3. groov

    nepaluz

    Joined:
    Sep 30, 2011
    Messages:
    1
    Likes Received:
    0
    If you use Windows to convert PayPal CSV or QIF files to OFX for import into any financial management software, try iCreateOFX PayPal OFX Converter (do a google search for it)
     
    nepaluz, Sep 30, 2011
    #3
  4. groov

    3Dmerchant

    Joined:
    May 28, 2011
    Messages:
    17
    Likes Received:
    0
    HI
    Paypal covered above.
    Let me know if you have trouble with the SagePay script. I can't fix that, but have an alternative solution. It is host-based so there is no software to purchase, but because Sage is 'closed' for integrations you would need a different processor, of which you can choose almost any.

    This information can all be collected at the time of the sale: Invoice number, amount, payment type, nominal code to pay into. I'm not sure what the reference is- auth code?, but custom fields are available. You can export the data via CSV or an API is also available.

    Christine
     
    3Dmerchant, Oct 24, 2011
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
There are no similar threads yet.
Loading...