Yes.
1.) Find (from the CoA tab)
For Invoices:
Do a Find where the Account matches AR and Value has Debits ≥ 0.00
For Bills:
Do a Find where the Account matches AP and Value has Credits ≥ 0.00
*For Credit Notes for each of AR/AP, change to Value has
Debits/Credits ≤ 0.00
2.) File > Export > Export Active Register to CSV while viewing one of
the above search results registers.
You might well end up with all splits for each invoice, not just one
line each. In that case, simply sort/massage as needed in a spreadsheet app.
Regards,
Adrien
On 12/29/21 1:40 AM, Omer Hayat wrote:
is there a way to export the list of invoices generated to excel? as well as
the vendor bills inputted into the system?
Scenario: We are a branch, and our main parent uses Quickbooks. Due to our low
volume of transactions, it will be easier to maintain our part of the accounts
separate, and just import them into their Quickbooks on a monthly basis.
We don’t need to import the complete chart of accounts etc, but just the
invoices and vendor bills.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
