Understanding SPED Book Type Definitions

You must submit the SPED accounting electronic files for specific types of GL accounts. For example, you must report information about balance sheet accounts, asset accounts, and transaction accounts.

You use the Book Type Definition program (P76B935) to set up information about the SPED books that you must report. You specify the purpose of the book, the order in which it appears in the file, the book type, and other related information. You also specify the ledger type from which the system reads the transaction information for the SPED book.

Most companies need to set up and report only book type G (daily books). You must set up other book types if some of the data that you must report resides in another software system, or if you generate some of the data files from another system for any other reason. When you generate data from more than one source, you must:

• Set up additional book types:

  • R (Daily Book with resumed bookkeeping)

  • A (Auxiliary daily book with resumed bookkeeping)

  • B (Daily Balance books and balance sheet)

  • S (SCP Book)

  • Z (Auxiliary major book)

  If you set up a book type R, you must also set up a book type A or Z. If you set up a book type B, you must also set up a book type Z.

  You can only set up a book type S if the company is an SCP company (if the ECD Type for the company is set to 2). For all other companies, you can set any book type except book type S.

• Associate the auxiliary book to the main book.

  Associate auxiliary book A with main book R. Associate auxiliary book Z with main book B.

• Associate GL accounts to books A and Z. You do not associate GL accounts to book types G, R, or Z.

The system stores the data that you enter in these tables.

• SPED Book Type Definition (F76B935)

  This table stores information about the main SPED books.

• SPED Book Type Relation (F76B936)

  This table stores the auxiliary book information.

• SPED Book Ledger Types (F76B937)

  This table stores the ledger type that you associate with the book type. The system selects transactional information for blocks I and J according the period, company, participant/subsidiary companies and the ledger type corresponding to the book for the job that you run.

You use the data that you set up for SPED books when you set up jobs to generate the electronic files for SPED accounting reporting. You use the SPED Job Administrator program (P76B940) to set up and run a job for each book that you set up in the Book Type Definition program.