python -m build
or another pep517 compatible tool to build/install it. See, e.g., the "Installation" section of the Arch Python package guidelines: https://wiki.archlinux.org/title/Python_package_guidelines
So for context I run a weird little partnership of freelancers who run projects through the company. I have two initial questions:
Question 1: Tracking project funds
Each project is treated kind of like a fund -- which is to say each project has its own set of assets / funds associated with the project, ultimately managed by the project's owner. I'm treating these assets as sub-accounts of our primary bank account.
So for instance:
2017-09-01 open Assets:MyBank:Checking:GeneralOperating
2018-03-18 open Assets:MyBank:Checking:ProjectA
2018-12-10 open Assets:MyBank:Checking:ProjectB
This is reasonable, but it does mean that I'm not able to track project resources until after a payment (e.g. I can't see what AccountsPayable / AccountsReceivable entries are associated with a project)
The other issue is that some of our projects have money in a second, non-USD, bank account. This just means I would have to have mirrored sub-accounts for those projects.
I looked into in using #tags to track project-based transactions but was blocked because sometimes a transaction might involve more than one project (e.g. a vendor might bill for more than one project in a single invoice) so I'm a bit stumped.
Question 2: Tracking Accounts Payable / vendors)
We also have vendors who help do some of the work who will invoice us. I want to be able to track how much we owe any given vendor, so I have created sub accounts of AccountsPayable. Also, at the end of the year I need to know how much I paid a given vendor for 1099-NECs, so I have sub-accounts of Expenses:
2018-08-20 open Expenses:Wages:JaneDoe USD
2018-08-20 open Liabilities:AccountsPayable:JaneDoe USD
I'll pause there for now -- are sub accounts the best way to handle this? The downside of this approach is that I have a ton more accounts (e.g. every time I add a new vendor I have to explicitly open an account for them; every time I close the books for the year I have to zero out each expense account individually).
Truly my goal is to be able to generate those two reports for the vendors (how much do I owe each vendor, and how much did I pay each vendor in a given fiscal period)
:point_up: Edit: So for context I run a weird little partnership of freelancers who run projects through the company. I have two initial questions:
Question 1: Tracking project funds
Each project is treated kind of like a fund -- which is to say each project has its own set of assets / funds associated with the project, ultimately managed by the project's owner. I'm treating these assets as sub-accounts of our primary bank account.
So for instance:
2017-09-01 open Assets:MyBank:Checking:GeneralOperating
2018-03-18 open Assets:MyBank:Checking:ProjectA
2018-12-10 open Assets:MyBank:Checking:ProjectB
This is reasonable, but it does mean that I'm not able to track project resources until after a payment (e.g. I can't see what AccountsPayable / AccountsReceivable entries are associated with a project)
The other issue is that some of our projects have money in a second, non-USD, bank account. This just means I would have to have mirrored sub-accounts for those projects.
I looked into in using #tags to track project-based transactions but was blocked because sometimes a transaction might involve more than one project (e.g. a vendor might bill for more than one project in a single invoice) so I'm a bit stumped.
Question 2: Tracking Accounts Payable / vendors)
We also have vendors who help do some of the work who will invoice us. I want to be able to track how much we owe any given vendor, so I have created sub accounts of AccountsPayable. Also, at the end of the year I need to know how much I paid a given vendor for 1099-NECs, so I have sub-accounts of Expenses:
2018-08-20 open Expenses:Wages:JaneDoe USD
2018-08-20 open Liabilities:AccountsPayable:JaneDoe USD
And then an invoice might be:
2018-08-20 * "Jane Doe " "invoice" ^2018-08-20-invoice-jdoe-1
Liabilities:AccountsPayable:JaneDoe 253.00 USD
Expenses:Wages:JaneDoe
and a payment might be
2018-10-29 * "Jane Doe" "payment" ^2018-08-20-invoice-jdoe-1 #ProjectA
Assets:Chase:Checking:ProjectA -253.00 USD
Liabilities:AccountsPayable:JaneDoe
I'll pause there for now -- are sub accounts the best way to handle this? The downside of this approach is that I have a ton more accounts (e.g. every time I add a new vendor I have to explicitly open an account for them; every time I close the books for the year I have to zero out each expense account individually).
Truly my goal is to be able to generate those two reports for the vendors (how much do I owe each vendor, and how much did I pay each vendor in a given fiscal period)
:point_up: Edit: So for context I run a weird little partnership of freelancers who run projects through the company. I have two initial questions:
Question 1: Tracking project funds
Each project is treated kind of like a fund -- which is to say each project has its own set of assets / funds associated with the project, ultimately managed by the project's owner. I'm treating these assets as sub-accounts of our primary bank account.
So for instance:
2017-09-01 open Assets:MyBank:Checking:GeneralOperating
2018-03-18 open Assets:MyBank:Checking:ProjectA
2018-12-10 open Assets:MyBank:Checking:ProjectB
This is reasonable, but it does mean that I'm not able to track project resources until after a payment (e.g. I can't see what AccountsPayable / AccountsReceivable entries are associated with a project)
The other issue is that some of our projects have money in a second, non-USD, bank account. This just means I would have to have mirrored sub-accounts for those projects.
I looked into in using #tags to track project-based transactions but was blocked because sometimes a transaction might involve more than one project (e.g. a vendor might bill for more than one project in a single invoice) so I'm a bit stumped.
Question 2: Tracking Accounts Payable / vendors)
We also have vendors who help do some of the work who will invoice us. I want to be able to track how much we owe any given vendor, so I have created sub accounts of AccountsPayable. Also, at the end of the year I need to know how much I paid a given vendor for 1099-NECs, so I have sub-accounts of Expenses:
2018-08-20 open Expenses:Wages:JaneDoe USD
2018-08-20 open Liabilities:AccountsPayable:JaneDoe USD
And then an invoice might be:
2018-08-20 * "Jane Doe " "invoice" ^2018-08-20-invoice-jdoe-1
Liabilities:AccountsPayable:JaneDoe 253.00 USD
Expenses:Wages:JaneDoe
and a payment might be
2018-10-29 * "Jane Doe" "payment" ^2018-08-20-invoice-jdoe-1
Assets:Chase:Checking:ProjectA -253.00 USD
Liabilities:AccountsPayable:JaneDoe
I'll pause there for now -- are sub accounts the best way to handle this? The downside of this approach is that I have a ton more accounts (e.g. every time I add a new vendor I have to explicitly open an account for them; every time I close the books for the year I have to zero out each expense account individually).
Truly my goal is to be able to generate those two reports for the vendors (how much do I owe each vendor, and how much did I pay each vendor in a given fiscal period)
:point_up: Edit: So for context I run a weird little partnership of freelancers who run projects through the company. I have two initial questions:
Question 1: Tracking project funds
Each project is treated kind of like a fund -- which is to say each project has its own set of assets / funds associated with the project, ultimately managed by the project's owner. I'm treating these assets as sub-accounts of our primary bank account.
So for instance:
2017-09-01 open Assets:MyBank:Checking:GeneralOperating
2018-03-18 open Assets:MyBank:Checking:ProjectA
2018-12-10 open Assets:MyBank:Checking:ProjectB
This is reasonable, but it does mean that I'm not able to track project resources until after a payment (e.g. I can't see what AccountsPayable / AccountsReceivable entries are associated with a project)
The other issue is that some of our projects have money in a second, non-USD, bank account. This just means I would have to have mirrored sub-accounts for those projects.
I looked into in using #tags to track project-based transactions but was blocked because sometimes a transaction might involve more than one project (e.g. a vendor might bill for more than one project in a single invoice) so I'm a bit stumped.
Question 2: Tracking Accounts Payable / vendors)
We also have vendors who help do some of the work who will invoice us. I want to be able to track how much we owe any given vendor, so I have created sub accounts of AccountsPayable. Also, at the end of the year I need to know how much I paid a given vendor for 1099-NECs, so I have sub-accounts of Expenses:
2018-08-20 open Expenses:Wages:JaneDoe USD
2018-08-20 open Liabilities:AccountsPayable:JaneDoe USD
And then an invoice might be:
2018-08-20 * "Jane Doe " "invoice" ^2018-08-20-invoice-jdoe-1
Liabilities:AccountsPayable:JaneDoe -253.00 USD
Expenses:Wages:JaneDoe
and a payment might be
2018-10-29 * "Jane Doe" "payment" ^2018-08-20-invoice-jdoe-1
Assets:Chase:Checking:ProjectA -253.00 USD
Liabilities:AccountsPayable:JaneDoe
I'll pause there for now -- are sub accounts the best way to handle this? The downside of this approach is that I have a ton more accounts (e.g. every time I add a new vendor I have to explicitly open an account for them; every time I close the books for the year I have to zero out each expense account individually).
Truly my goal is to be able to generate those two reports for the vendors (how much do I owe each vendor, and how much did I pay each vendor in a given fiscal period)
:point_up: Edit: So for context I run a weird little partnership of freelancers who run projects through the company. I have two initial questions:
Question 1: Tracking project funds
Each project is treated kind of like a fund -- which is to say each project has its own set of assets / funds associated with the project, ultimately managed by the project's owner. I'm treating these assets as sub-accounts of our primary bank account.
So for instance:
2017-09-01 open Assets:MyBank:Checking:GeneralOperating
2018-03-18 open Assets:MyBank:Checking:ProjectA
2018-12-10 open Assets:MyBank:Checking:ProjectB
This is reasonable, but it does mean that I'm not able to track project resources until after a payment (e.g. I can't see what AccountsPayable / AccountsReceivable entries are associated with a project)
The other issue is that some of our projects have money in a second, non-USD, bank account. This just means I would have to have mirrored sub-accounts for those projects.
I looked into in using #tags to track project-based transactions but was blocked because sometimes a transaction might involve more than one project (e.g. a vendor might bill for more than one project in a single invoice) so I'm a bit stumped.
Question 2: Tracking Accounts Payable / vendors
We also have vendors who help do some of the work who will invoice us. I want to be able to track how much we owe any given vendor, so I have created sub accounts of AccountsPayable. Also, at the end of the year I need to know how much I paid a given vendor for 1099-NECs, so I have sub-accounts of Expenses:
2018-08-20 open Expenses:Wages:JaneDoe USD
2018-08-20 open Liabilities:AccountsPayable:JaneDoe USD
And then an invoice might be:
2018-08-20 * "Jane Doe " "invoice" ^2018-08-20-invoice-jdoe-1
Liabilities:AccountsPayable:JaneDoe -253.00 USD
Expenses:Wages:JaneDoe
and a payment might be
2018-10-29 * "Jane Doe" "payment" ^2018-08-20-invoice-jdoe-1
Assets:Chase:Checking:ProjectA -253.00 USD
Liabilities:AccountsPayable:JaneDoe
I'll pause there for now -- are sub accounts the best way to handle this? The downside of this approach is that I have a ton more accounts (e.g. every time I add a new vendor I have to explicitly open an account for them; every time I close the books for the year I have to zero out each expense account individually).
Truly my goal is to be able to generate those two reports for the vendors (how much do I owe each vendor, and how much did I pay each vendor in a given fiscal period)
I should probably learn what running a report is 😅
I think your second suggestion (running the report on the internal abstraction / on the project, rather than the external structure / the account) would be easier to swing simply because when I'm ingesting data from my bank account (e.g. for the example vendor payment above) the account the statement / data is related to is Assets:MyBank:Checking
, not broken down by project.
(ty by the way, I'll check this out!)
project: MyProjectA
or whatever (I can't tell if this would get super tedious, or if this is simply the intention of metadata... I truly truly wish I could use #tags since it seems the fava interface treats tags as a first class piece of metadata in its UX)
@gary I am storing invoices alongside my ledger; do you know if it's possible to maintain a document structure that doesn't mirror accounts directly (e.g. if I track vendor using the Payee model)? With sub-accounts I had each invoice in a ./Liabilities/AccountsPayable/VendorNameHere
which aligned with the account. Fava seemed opinionated about that file structure, but I'm wondering if maybe I'm not so locked in.
(or, alternatively maybe I keep the AP sub-accounts but ditch the expense sub-accounts. food for thought.)
I know I'm saying thanks a lot but why stop now: thank you so much for the advice
Wages
block)
plugin "fava.plugins.link_documents"
in my ledger (btw what is the "noun" for a beancount document? is it ledger? recordset?)