How to deploy to produce the desired outputs from CSV (BAS)?

[zenny]

Hi @kjelloh This appears to be a something very desired.

Can you explain how to employ in real-time situation?

Cheers, /z

[kjelloh]

Hi!

Thank you for being so interested in this project!

Sorry to say the project is in a very very early state! So far I have it on Github only as a backup for my own development :)

1) What is it you are trying to do?

Best regards, Kjell-Olov

On 24 Feb 2022, at 09:31, zenny @.***> wrote:

Hi @kjelloh https://github.com/kjelloh This appears to be a something very desired.

Can you explain how to employ in real-time situation?

Cheers, /z

— Reply to this email directly, view it on GitHub https://github.com/kjelloh/cratchit/issues/1, or unsubscribe https://github.com/notifications/unsubscribe-auth/AELGXDYOFQ5PUZYBRFVQOYDU4XUEJANCNFSM5PGWAA7A. Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub. You are receiving this because you were mentioned.

[zenny]

On Thu, Mar 3, 2022 at 6:40 PM kjelloh @.***> wrote:

Hi!

Thank you for being so interested in this project!

Sorry to say the project is in a very very early state! So far I have it on Github only as a backup for my own development :)

Yep, that sounds very interesting, too.

1) What is it you are trying to do?

I am trying to brute force the CSV from any Swedish Bank to produce a compatible documents, ready to submit to Bolagsverket instead of using a 3rd party services for accounting, for the sake of privacy. I have seen a few implementation in the same direction by a github user 'byrokrat'.

Best regards, Kjell-Olov

Cheers, /z

On 24 Feb 2022, at 09:31, zenny @.***> wrote:

Hi @kjelloh https://github.com/kjelloh This appears to be a something very desired.

Can you explain how to employ in real-time situation?

Cheers, /z

— Reply to this email directly, view it on GitHub < https://github.com/kjelloh/cratchit/issues/1>, or unsubscribe < https://github.com/notifications/unsubscribe-auth/AELGXDYOFQ5PUZYBRFVQOYDU4XUEJANCNFSM5PGWAA7A . Triage notifications on the go with GitHub Mobile for iOS < https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android < https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

You are receiving this because you were mentioned.

— Reply to this email directly, view it on GitHub https://github.com/kjelloh/cratchit/issues/1#issuecomment-1058310569, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAMTTLROM6N6SARVUQOOM4LU6D2QHANCNFSM5PGWAA7A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you authored the thread.Message ID: @.***>

-- Cheers, /z

-.. .. ... -.-. .-.. .- .. -- . .-. | -.. .. ... -.-. .-.. .- .. -- . .-. CONFIDENTIALITY NOTICE AND DISCLAIMER: Access to this e-mail and its contents by anyone other than the intended recipient is unauthorized as it contains privileged and confidential information, and is subject to legal privilege. Please do not re/distribute it. If you are not the intended recipient (or responsible for delivery of the message to such person), you may not use, copy, distribute or deliver the email and part of its contents to anyone this message (or any part of its contents or take any action in connection to it. In such case, you should destroy this message, and notify the sender immediately. If you have received this email in error, please notify the sender or your sysadmin immediately by e-mail or telephone, and delete the e-mail from any computer. If you or your employer does not consent to internet e-mail messages of this kind, please notify the sender immediately. All reasonable precautions have been taken to ensure no viruses are present in this e-mail and attachments included. As the sender cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments it is recommended that you are responsible to follow your virus checking procedures prior to use. The views, opinions, conclusions and other informations expressed in this electronic mail are not given or endorsed by any company including the network providers unless otherwise indicated by an authorized representative independent of this message. -.. .. ... -.-. .-.. .- .. -- . .-. | -.. .. ... -.-. .-.. .- .. -- . .-.

[kjelloh]

My aim with cratchit is somewhat aligned with your intent to transform Bank CSV files in to files to bolagsverket :).

==> Only - I plan to be able to turn bank CSV into SIE-file entries to import to a book keeping app. For me that will suffice as a starter.

But - If you keep in touch and track my progress maybe I may end up with something also you can use. No promises! But could be a fun spin off from this project :)

I wish you good luck with your own goals!

/kjelloh

[zenny]

My aim with cratchit is somewhat aligned with your intent to transform Bank CSV files in to files to bolagsverket :).

Glad to know. :D

==> Only - I plan to be able to turn bank CSV into SIE-file entries to import to a book keeping app. For me that will suffice as a starter.

Yep me, too!

But - If you keep in touch and track my progress maybe I may end up with something also you can use. No promises! But could be a fun spin off from this project :)

Certainly!

I wish you good luck with your own goals!

Reciprocate the same! Tack!

/kjelloh

[zenny]

My aim with cratchit is somewhat aligned with your intent to transform Bank CSV files in to files to bolagsverket :).

==> Only - I plan to be able to turn bank CSV into SIE-file entries to import to a book keeping app. For me that will suffice as a starter.

But - If you keep in touch and track my progress maybe I may end up with something also you can use. No promises! But could be a fun spin off from this project :) Long time since we communicated

Have you accomplished to tranform CSV to the Bolagsverket's SIE-BAS standards? If yes, can this be compiled in linux?

Thanks!

I wish you good luck with your own goals!

/kjelloh

[kjelloh]

Hi!

Thank you for your interest.

My Cratchit App is still not very user friendly.

==> It does read CSV-files from NORDEA and SKV but so far only to an internal format I call "Tagged Amounts".

There is a user interface to turn them into entries in an SIE-file for import to an external app.

So all the logic is there (for NORDEA CSV and SIE file processing) but the code to automate it is not...

But if you keep tracking my progress on Github you may perhaps detect a commit where I mention your name and possibly have some good news ;)

Until then, take care and good luck finding a way to solve you CSV to SIE needs!

/Kjell-Olov

On 23 Feb 2024, at 13:41, zenny @.***> wrote:

My aim with cratchit is somewhat aligned with your intent to transform Bank CSV files in to files to bolagsverket :).

==> Only - I plan to be able to turn bank CSV into SIE-file entries to import to a book keeping app. For me that will suffice as a starter.

But - If you keep in touch and track my progress maybe I may end up with something also you can use. No promises! But could be a fun spin off from this project :) Long time since we communicated

Have you accomplished to tranform CSV to the Bolagsverket's SIE-BAS standards? If yes, can this be compiled in linux?

Thanks!

I wish you good luck with your own goals!

/kjelloh

— Reply to this email directly, view it on GitHub https://github.com/kjelloh/cratchit/issues/1#issuecomment-1961258771, or unsubscribe https://github.com/notifications/unsubscribe-auth/AELGXD2ORV4GXTSH2XVASW3YVCE6ZAVCNFSM5PGWAA7KU5DIOJSWCZC7NNSXTN2JONZXKZKDN5WW2ZLOOQ5TCOJWGEZDKOBXG4YQ. You are receiving this because you were mentioned.

[kjelloh]

Hi Zenny!

You know what?

==> Can you tell me more about how you want the "transform CSV to the Bolagsverket's SIE-BAS standards" to work?

Do you imagine to provide some mapping file so that the process can know how to interpret the CSV file transactions to full-fledged SIE transactions? I mean, as far as I have analysed the contents of the CSV file from NORDEA bank account the headings and other information is not enough to know how each transaction should me mapped to an entry in the books? Looking forward to hear from you and some more details on your thoughts and wish-list :). Take care!

[zenny]

Hi Zenny!

You know what?

==> Can you tell me more about how you want the "transform CSV to the Bolagsverket's SIE-BAS standards" to work?

Do you imagine to provide some mapping file so that the process can know how to interpret the CSV file transactions to full-fledged SIE transactions? I mean, as far as I have analysed the contents of the CSV file from NORDEA bank account the headings and other information is not enough to know how each transaction should me mapped to an entry in the books? Looking forward to hear from you and some more details on your thoughts and wish-list :). Take care!

Thanks @kjelloh for asking.

Btw, there are several online provides including the dooer to which you can import the CSV file after making some changes to the CSV headers. Yet it cannot make an entry based on the chart of accounts (https://www.bas.se/wp-content/uploads/2017/06/Chart-of-accounts-2022.xlsx OR https://www.bas.se/wp-content/uploads/2022/01/Kontoplan-2022.pdf). One ought to do manually to produce the required bookkeeping entries which too is different from what you submit to Bolagsverket. I am sure you are aware of that.

What I wish for is to produce the balance sheet and other documents as well as the report to submit to the Bolagsverket, based on the CSV file (with necessary modifications with the numbers associated with chart of accounts if needed) import.

I explain what I meant. Usually the bank statements tend to have the following in the CSV file (without any association of chart of accounts). For example:

Transaktionsdatum;Beskrivning;Belopp;Balans
2024-01-01;Bankintyg;-995,00;204005,00
2020-01-01;FORETAGSCONTO;205000,00;205000.00

In the above case the description does not say a word about the chart of accounts, so it is worth adding a column (Kontoplan) part as follows:

Bokföringsdatum;Beskrivning;Belopp;Balans;Kontoplan
2024-01-01;Bankintyg;-995,00;204005,00;6570
2024-01-01;FORETAGSCONTO;205000,00;205000.00;1383

Where 6570 is associated with Bankkostnader and 1383 is associated with Lämnade depositioner, långfristiga in the BAS chart of accounts.

Once the modified CSV with the associated numerical codes at the end are imported, the entries gets booked and the balance sheet and profit and loss statements as well as the report to Bolagsverket be generated with the inputs under certain header extracted from a txt file for description.

I guess that would be ideal to avoid manual bookkeeping. Just my two ore.

Cheers,