A crazy idea (but it works)

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

A crazy idea (but it works)

Tim Hume
Hi everyone,

I need to enter moderately complex split transactions into Gnucash. One of the splits is a transfer between accounts in different currencies,  the other is a transfer between accounts in the same currency (a fee charged to the customers).

The original data comes from a spreadsheet. I have dozens or hundreds of these to enter each week, and doing it manually was becoming too burdensome. I tried importing using various formats. QIF almost worked, but couldn't handle the different currencies. OFX might have worked, if I could work out all the details. I might have been able to use the python bindings too.

But what I've ended up doing is "automating" the manual process using something called sikulix. It's like having a robot sitting in front of the computer entering in the transactions. It's a crazy idea, but works sweet. Now I can leave the tedious and repetitive task to the computer, and it's more accurate than me entering the transactions by hand.

Cheers,

Tim.
_______________________________________________
gnucash-user mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Reply | Threaded
Open this post in threaded view
|

Re: A crazy idea (but it works)

Michael DeBusk-2
On Mon, Feb 6, 2017 at 3:37 PM, Tim Hume <[hidden email]> wrote:

> But what I've ended up doing is "automating" the manual process using something called sikulix.
> It's like having a robot sitting in front of the computer entering in the transactions.

I've long wondered if something like this was available for Linux.

http://sikulix.com/
_______________________________________________
gnucash-user mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Reply | Threaded
Open this post in threaded view
|

Re: A crazy idea (but it works)

Sébastien de Menten
In reply to this post by Tim Hume
Crazy idea indeed ;-)
Could you share your configuration/scripts for Sikuli ?

On Feb 6, 2017 21:41, "Tim Hume" <[hidden email]> wrote:

> Hi everyone,
>
> I need to enter moderately complex split transactions into Gnucash. One of
> the splits is a transfer between accounts in different currencies,  the
> other is a transfer between accounts in the same currency (a fee charged to
> the customers).
>
> The original data comes from a spreadsheet. I have dozens or hundreds of
> these to enter each week, and doing it manually was becoming too
> burdensome. I tried importing using various formats. QIF almost worked, but
> couldn't handle the different currencies. OFX might have worked, if I could
> work out all the details. I might have been able to use the python bindings
> too.
>
> But what I've ended up doing is "automating" the manual process using
> something called sikulix. It's like having a robot sitting in front of the
> computer entering in the transactions. It's a crazy idea, but works sweet.
> Now I can leave the tedious and repetitive task to the computer, and it's
> more accurate than me entering the transactions by hand.
>
> Cheers,
>
> Tim.
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
_______________________________________________
gnucash-user mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.