A comprehensive .NET library for parsing and exporting QuickBooks data. Provides models and services for reading QuickBooks files and exporting data to Excel and CSV formats.
$ dotnet add package BizzelTech.QuickBooksA comprehensive .NET library specifically designed for QuickBooks data processing, parsing, and export capabilities. Built to seamlessly integrate with BizzelTech.Excel for professional data exports.
BizzelTech.QuickBooks is a specialized library that provides:
dotnet add package BizzelTech.QuickBooks
using BizzelTech.QuickBooks.Models;
using BizzelTech.QuickBooks.Services;
// Create QuickBooks data
var quickBooksData = new QuickBooksData
{
CompanyName = "Acme Corporation",
Customers = new List<Customer>
{
new Customer
{
Name = "Client ABC",
Balance = 15000.00m,
Email = "contact@clientabc.com"
}
},
Transactions = new List<Transaction>
{
new Transaction
{
Date = DateTime.Now,
Type = "Invoice",
Customer = "Client ABC",
Amount = 5000.00m,
Description = "Consulting services"
}
}
};
// Export to Excel with professional formatting
var exporter = new DataExporter(logger);
await exporter.ExportToExcelAsync(quickBooksData, "company_report.xlsx");
// Export to CSV files
await exporter.ExportToCsvAsync(quickBooksData, "csv_exports/");
Complete set of business entities:
// Program.cs or Startup.cs
services.AddTransient<IDataExporter, DataExporter>();
services.AddTransient<IQuickBooksReader, QuickBooksFileReader>();
// Usage in your services
public class ReportingService
{
private readonly IDataExporter _exporter;
public ReportingService(IDataExporter exporter)
{
_exporter = exporter;
}
public async Task GenerateMonthlyReportAsync(QuickBooksData data)
{
await _exporter.ExportToExcelAsync(data, "monthly_report.xlsx");
}
}
var exportOptions = new ExportOptions
{
IncludeSummary = true,
CurrencyFormat = "$#,##0.00",
DateFormat = "MM/dd/yyyy",
CompanyLogo = "path/to/logo.png"
};
await exporter.ExportToExcelAsync(quickBooksData, "report.xlsx", exportOptions);
A complete sample application is available showing:
# Clone and run the sample
git clone https://github.com/yourusername/BizzelTools.git
cd BizzelTools/samples/BizzelTools.QuickBooks.Sample
dotnet run
BizzelTech.QuickBooks is designed to work seamlessly with BizzelTech.Excel:
// The DataExporter automatically uses BizzelTech.Excel's fluent API
var exporter = new DataExporter(logger);
// Results in professional Excel files with:
// - Multiple worksheets (Customers, Vendors, Transactions, etc.)
// - Formatted headers with bold text and background colors
// - Currency formatting for all monetary fields
// - Date formatting for transaction dates
// - Summary worksheet with company overview and totals
await exporter.ExportToExcelAsync(quickBooksData, "professional_report.xlsx");
This project is licensed under the MIT License. See the LICENSE file for details.
BizzelTech.QuickBooks - Professional QuickBooks data processing for .NET applications.
Built for developers who need reliable, well-documented tools for business data processing.