[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