[GNC] Exporting invoices and vendor bills to excel or Quickbooks

[Adrien Monteleone]

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.