[GNC] automatically account for gst on random purchases

flywire flywire0 at gmail.com
Wed Jun 21 09:49:43 EDT 2023


This is a preliminary (spreadsheet) process to add GST splits to a bank
statement and use a multisplit csv file to import them to GnuCash.

   1. Start with Bank Statement based on the Guide Checking Account  -
   see GST_Demo_Statement.csv
   2. Accounts should exist for the transactions -
   see GST_Demo_Accounts.csv and the Note for GST accounts
   3. Unique account strings are required to identify Accounts -
   see GST_Demo_AccountKeywords.csv
   4. Each of the above csv files can be copied to a sheet in a spreadsheet
   to lookup the Account and GST fields - see GST_Demo_Statement_Accounted.csv
   5. A process is run to create the GST split in a multisplit csv file -
   see GST_Demo_Statement_Multisplit.csv

Let's create the GnuCash GST_Demo file:

*Note:* GnuCash V5.1 has a bug preventing the multisplit file from loading
amounts. Either load GnuCash V4 and translate all the labels or run V5.1
anyway assigning value to an empty column to see the process without values.

Run GnuCash

Create the accounts:

File, New file, Cancel
File, Import, Import accounts from CSV, Next, Choose file to import:
GST_Demo_Accounts.csv, Import account preview: 1 row in header, comma
separated, Next, Import accounts now: Apply, New book options: Close, A
message should display 21 accounts created: Close.

You can examine the accounts created.

Import the Checking Account transactions:

File, Import, Import transactions from CSV, Next, Choose file to import:
GST_Demo_Statement_Multisplit.csv, Import  preview: File format:
Separators, Comma, Multi-split, Miscellaneous: Date format - d-m-y, Leading
lines to skip - 1, Select columns - Date, Number, Description, Amount
(negated), Amount, Price (assigned to empty column to workaround bug),
Account, Next, Match import and GnuCash accounts: Next, Transaction
information: Next, Match transactions: Apply, Import summary: Close

In the Accounts tab double click on Bank:Checking to open the account,
View, Transaction journal.

Regards

>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GST_Demo_Statement.csv
Type: text/csv
Size: 809 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230621/c143fbdd/attachment.csv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GST_Demo_Accounts.csv
Type: text/csv
Size: 1289 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230621/c143fbdd/attachment-0001.csv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GST_Demo_AccountKeywords.csv
Type: text/csv
Size: 303 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230621/c143fbdd/attachment-0002.csv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GST_Demo_Statement_Accounted.csv
Type: text/csv
Size: 1135 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230621/c143fbdd/attachment-0003.csv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GST_Demo_Statement_Multisplit.csv
Type: text/csv
Size: 1376 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230621/c143fbdd/attachment-0004.csv>


More information about the gnucash-user mailing list